pass/fail if value is between two numbers

I need to return a PASS or FAIL if a result is between two numbers.

I.E IF cell C5 <250 or >300 then FAIL otherwise PASS

Brilliant so simple really. Thanks

Originally Posted by DonkeyOte

You can use MEDIAN

Please Login or Register  to view this content.

else an AND based test

Please Login or Register  to view this content.

or reverse logic and use OR test

Please Login or Register  to view this content.