| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF AND returning #VALUE!
I have what I thought was a simple formula I wanted to return a value based on the condition (TRUE or FALSE) of two cells. They are either both true, both false, one is false and the other true, or one is true and the other false.
IF(AND(ER18=TRUE,ET18=TRUE),ER22),IF(AND(ER18=FALS E,ET18=TRUE),ER23),IF(AND(ER18=TRUE,ET18=FALSE),ER 24),IF(AND(ER18=FALSE,ET18=FALSE),ER25) This is giving me a result of "#VALUE!" I do this so seldom, that I'm sure I've got it wrong but, it's 1AM and I'm not seeing it. Any help, very very much appreciated! Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested If not returning correct values | Excel Discussion (Misc queries) | |||
| nested IF(OR Vlookup returning zero instead of value in target cel | Excel Worksheet Functions | |||
| Nested If statements returning a sum calculation | Excel Worksheet Functions | |||
| Nested if returning error 1004 | Excel Programming | |||
| Nested "if" not returning expected value | Excel Worksheet Functions | |||
Threaded Mode
