Check If Numbers are between two Numbers and Over and Under Two Numbers

[meyero90]

Hello,
I have tried IF formulas to check if a Number is between two set numbers (upper/lower limits) and also check if it's over and under.
The formula should return "GOOD" if number is between the upper/lower limit, and "OVER" if it's over the upper limit, and "UNDER" if it's under the lower limit.

See attached my excel which only returns "GOOD" (unfortunately)

[gmr4evr1]

Try this...

Please Login or Register  to view this content.

EDIT* Forgot the under part...working on it.

[SlipEternal]

You need to use AND to check multiple conditions. See the updated spreadsheet.

[gmr4evr1]

Try this one instead

Please Login or Register  to view this content.

meyero90-check-if-numbers-are-between-two-numbers-and-over-and-under-two-numbers-formula-check.xlsx

[meyero90]

Thanks for this but how about showing the result "UNDER" if it's under the lower limit

[AlKey]

Try this

Please Login or Register  to view this content.

[gmr4evr1]

Thanks for this but how about showing the result "UNDER" if it's under the lower limit

The amended formula I put in post #4 should have done this, did it not?

[Jonmo1]

This is assuming B7 is in fact a larger number than B6.

=IF(B2<B6,"Under",IF(B2>B7,"Over","Good"))