| 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=567101 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested IF Statement
Duplicate Thread! Delete please. -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709 View this thread: http://www.excelforum.com/showthread...hreadid=567101 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Nested IF statement with Between operator | Excel Worksheet Functions | |||
| :confused: Nested if then else statement | Excel Worksheet Functions | |||
| Nested IF Statement Question | Excel Discussion (Misc queries) | |||
| Problem with nested IF_OR statement | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Linear Mode
