ChatterBank1 min ago
EXCEL Expert Needed
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
Answers
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.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.