| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three condition "if" statements
I'm trying to write an IF statement that needs to look at the input of three
cells (D4, D5 and D6). If any of them are "YES" then I need cell E4 to = cell G1. However, If they are all "no" then I need cell E4 to = cell G2 Finally, if they are all blank then I need cell e4 to be blank Also, if I do this can I conditionally format cell E4 so if it = G1 then it is White text on a red background, and if it = G2 then it is Black text on a green background (I'm okay with CF just need to know if it's possible) Looking forward to your replies. TVM Terry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Need more than 7 nested "IF" statements in Excel" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
