| 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=567103 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested IF Statement
=IF(D7<0,"Invalid Value",IF(D7=0,"Not Evaluated",IF(D7<10,"Fail",IF(D7=10,
"Pass", "Invalid Value")))) Vaya con Dios, Chuck, CABGx3 "aposatsk" wrote: 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=567103 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested IF Statement
What if the result is 10 ????
=IF(D7<0,"Invalid Value",IF(D7=0,"Not Evaluated",IF(D7<10,"Fail",IF(D7=10, "Pass", "??")))) If =10 is a PASS then: =IF(D7<0,"Invalid Value",IF(D7=0,"Not Evaluated",IF(D7<10,"Fail", "Pass"))) "aposatsk" wrote: 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=567103 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested IF Statement
If 10 is "Invalid Value" .....
=IF(OR(D7<0,D710),"Invalid Value",IF(D7=0,"Not Evaluated",IF(D7<10,"Fail", "Pass"))) "Toppers" wrote: What if the result is 10 ???? =IF(D7<0,"Invalid Value",IF(D7=0,"Not Evaluated",IF(D7<10,"Fail",IF(D7=10, "Pass", "??")))) If =10 is a PASS then: =IF(D7<0,"Invalid Value",IF(D7=0,"Not Evaluated",IF(D7<10,"Fail", "Pass"))) "aposatsk" wrote: 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=567103 |
| 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 | |||
Hybrid Mode
