Thread: Nested IF Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aposatsk aposatsk is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote