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

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

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

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