| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF Statement
How can I modify this IF statement to also display "Invalid Value" if "D7 < 0" ? =IF(D7=0,"Not Evaluated",IF(D7<10,"Fail",IF(D7=10, "Pass", "Invalid Value"))) -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709 View this thread: http://www.excelforum.com/showthread...hreadid=567102 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| :confused: Nested if then else statement | Excel Worksheet Functions | |||
| Nested IF Statement Question | Excel Discussion (Misc queries) | |||
| Nested SumIf statement | Excel Worksheet Functions | |||
| Problem with nested IF_OR statement | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Threaded Mode
