IF(OR where the value can be a number or text

[Snake Eyes]

In this formula I'm trying to check for a number entered in D43 that is outside the range of -150 and 250 OR if the text entered is not NL.

=IF(D43<>"NL","Complete the checklist",IF(OR(D43<=-150,D43>=250),"Outside range - complete checklist","next check"))

The problem is that any number entered is going to return true since it's not = NL even if the number is outside the range.
How do I account for a mix of text and numbers in the statement, which is where I think the problem lies?

 

[Jeffrey Mahoney]

Does this solve the problem?
=IF(AND(D43<>"NL",OR(D43<=-150,D43>=250)),"Outside range - complete checklist",IF(D43<>"NL","Complete Checklist","Next Check"))

 

[Snake Eyes]

Does this solve the problem?
=IF(AND(D43<>"NL",OR(D43<=-150,D43>=250)),"Outside range - complete checklist",IF(D43<>"NL","Complete Checklist","Next Check"))

Jeffrey,
- Your solution returns "complete checklist" if the value is inside the range of -150 and 250.
+ Values outside that range do return "Outside range - complete checklist".
+ NL does return "next check"

 

[Fluff]

How about

=IF(AND(ISNUMBER(D43),OR(D43<=-150,D43>=250)),"Outside range - complete checklist",IF(AND(ISTEXT(D43),D43<>"NL"),"Complete Checklist","Next Check"))

 

[Snake Eyes]

How about

=IF(AND(ISNUMBER(D43),OR(D43<=-150,D43>=250)),"Outside range - complete checklist",IF(AND(ISTEXT(D43),D43<>"NL"),"Complete Checklist","Next Check"))

TY you Fluff.
That worked.

 

[Fluff]

Glad we could help & thanks for the feedback.