EXCEL 2010
I am trying to do the following IF in sheet "Main Console"
cell "E19" displays an 11 and "F19" Displays a 9
OR
cell "E19" displays a 9 and "F19" displays an "11"
AND
cell "G19" displays a 3
show the following - 20% otherwise display blank
Here are the formula's I have tried so far but have not worked.......
=IF('Main Console'!G19=3,AND(OR('Main Console'!E19=11,'Main Console'!F19=9,'Main Console'!E19=9,'Main Console'!F19=11),0.2,""))
=IF('Main Console'!G19=3,AND('Main Console'!E19=11,'Main Console'!F19=9,OR('Main Console'!F19=11,'Main Console'!E19=9),0.2,""))
=IF(OR('Main Console'!E19=11,'Main Console'!F19=9,'Main Console'!F19=11,'Main Console'!E19=9)*AND('Main Console'!G19=3),0.2,"")
The bottom one worked however regardelss of what is in cells E19 and F19 if G19 had a 3 in it, it would display all the % I had for other if functions involving that G19 cell with a 3
Please help as I am now clueless........
I am trying to do the following IF in sheet "Main Console"
cell "E19" displays an 11 and "F19" Displays a 9
OR
cell "E19" displays a 9 and "F19" displays an "11"
AND
cell "G19" displays a 3
show the following - 20% otherwise display blank
Here are the formula's I have tried so far but have not worked.......
=IF('Main Console'!G19=3,AND(OR('Main Console'!E19=11,'Main Console'!F19=9,'Main Console'!E19=9,'Main Console'!F19=11),0.2,""))
=IF('Main Console'!G19=3,AND('Main Console'!E19=11,'Main Console'!F19=9,OR('Main Console'!F19=11,'Main Console'!E19=9),0.2,""))
=IF(OR('Main Console'!E19=11,'Main Console'!F19=9,'Main Console'!F19=11,'Main Console'!E19=9)*AND('Main Console'!G19=3),0.2,"")
The bottom one worked however regardelss of what is in cells E19 and F19 if G19 had a 3 in it, it would display all the % I had for other if functions involving that G19 cell with a 3
Please help as I am now clueless........