| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is wrong with this nested function?
I have entered the following nested function, but it says the formula
contains an error. =IF(SUM(E55:E67)=3, "Red"), (SUM(D55:D67)=2, "Amber"), "Green" Basically, I want the word, "Pink" to appear if SUM(E55:E67)=3; the word, "Yellow" to appear if SUM(D55:D67)=2; and the word "Blue" to appear otherwise. Anyone know how I can do this? Any help would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF's with Logical Arguments - Doing something wrong here | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong here | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong her | Excel Discussion (Misc queries) | |||
| Nested IF's with Logical Arguments - Doing something wrong her | Excel Discussion (Misc queries) | |||
| Nested subtotal figures in wrong order | Excel Discussion (Misc queries) | |||
Threaded Mode
