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

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