Help on IF condition
 

I want cell 'G4' to show "Red" if the value Cell 'D4' is greater than the
value of 'A7' and 'E4' is greater than 'A9' and show "Green" if any one of
them is less than 'A7' or 'A9' respectively.
I tried a formula but it didn't work as I expected.
=IF(AND(D4$A$7,E4$A$9),"Red","Green")
Any suggestions would be appreciated.

Thanks..
--
Karthi

Help on IF condition
 

=IF(AND(D4$A$7,E4$A$9),"Red","Green")
will display Green for all conditions unless d4 and E4 are greater than...
If blank or equal, then you need to deal with that as well..

=IF(AND(D4$A$7,E4$A$9),"Red",IF(OR(D4<$A$7,E4<$A $9),"Green",""))
--
If this post helps click Yes
---------------
Jacob Skaria


"Karthik" wrote:

I want cell 'G4' to show "Red" if the value Cell 'D4' is greater than the
value of 'A7' and 'E4' is greater than 'A9' and show "Green" if any one of
them is less than 'A7' or 'A9' respectively.
I tried a formula but it didn't work as I expected.
=IF(AND(D4$A$7,E4$A$9),"Red","Green")
Any suggestions would be appreciated.

Thanks..
--
Karthi

Help on IF condition
 

Thanks Jacob,
--
Karthi


"Jacob Skaria" wrote:

=IF(AND(D4$A$7,E4$A$9),"Red","Green")
will display Green for all conditions unless d4 and E4 are greater than...
If blank or equal, then you need to deal with that as well..

=IF(AND(D4$A$7,E4$A$9),"Red",IF(OR(D4<$A$7,E4<$A $9),"Green",""))
--
If this post helps click Yes
---------------
Jacob Skaria


"Karthik" wrote:

I want cell 'G4' to show "Red" if the value Cell 'D4' is greater than the
value of 'A7' and 'E4' is greater than 'A9' and show "Green" if any one of
them is less than 'A7' or 'A9' respectively.
I tried a formula but it didn't work as I expected.
=IF(AND(D4$A$7,E4$A$9),"Red","Green")
Any suggestions would be appreciated.

Thanks..
--
Karthi