Donate SIGN UP

EXCEL Expert Needed

Avatar Image
willprentice | 12:33 Sun 05th Sep 2004 | Technology
3 Answers
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
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by willprentice. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
=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"
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.
=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"))

1 to 3 of 3rss feed

Do you know the answer?

EXCEL Expert Needed

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.