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

=IF(MEDIAN(250,300,C5)=C5,"Pass","Fail")

else an AND based test

=IF(AND(C5>=250,C5<=300),"Pass","Fail")

or reverse logic and use OR test

=IF(OR(C5<250,C5>300),"Fail","Pass")