| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need MAX value if condition is met | Excel Worksheet Functions | |||
| Condition | Excel Discussion (Misc queries) | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| Condition 1 overules condition 2? | Excel Worksheet Functions | |||
Linear Mode
