EXCEL Expert Needed

[willprentice]

Can someone please tell me what function to use in MS excel to make the following work: example: the number in cell A1will be within the range of 1 - 10. If the number range is 1-5 then cell A2 must read 'FAIL'. If the number range is 6-10 call A2 must read 'PASS'. Any ideas? Cheers

[pinus]

=IF(A1<6,"FAIL","PASS") This produce FAIL or PASS for numbers outside the range 1-10 You construct a formula like this using the drop-down menu and selecting "IF"

[pinus]

I've just re-read what I posted. I meant to say that this formula will *also* produce results for numbers outside the specified range I try to keep individual formulae simple, so if I wanted to ensure that only numbers in the range 1 -10 were possible, I'd introduce a separate test.

[Tweed]

=IF(AND(A2>0,A2<6),"FAIL",IF(AND(A2>5,A2<11),"PASS")) or =IF(AND(A1>0,A1<6),"FAIL",IF(AND(A1>5,A1<11),"PASS","Outside range"))