Nested IF Statement

  • Thread starter Thread starter aposatsk
  • Start date Start date
A

aposatsk

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")))
 
=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
 
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")))
 
If > 10 is "Invalid Value" .....

=IF(OR(D7<0,D7>10),"Invalid Value",IF(D7=0,"Not Evaluated",IF(D7<10,"Fail",
"Pass")))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum if statement 3
If condition to find Target 2
IF Statement in a macro: 2
Formula in a cell depending on the value of another cell 1
multi, nested functions... 6
sum of multiple conditional funtions....??? 5
Please Help with Macro Code 1
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1

Back
Top