I need to take something from cell J7 which could be a number or text. If it is a number, I need to determine if the number qualifies as a 'Pass' or 'Fail', and if it is text, I need it to return 'n/a'. Currently, the pass and fail work, but if it is text then it returns False instead of the 'n/a'.
Help please. Here is my current formula:
=IF(ISNUMBER(J7),IF(J7<=187,"FAIL",IF(J7>=188,"PASS","n/a")))
Thanks!
=IF(ISNUMBER(J7),IF(J7<=187,"FAIL","PASS"),"n/a")
I reckon
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks JosephP. When I enter your modification, it then tells me I have too many arguments for this function...
I reckon you copied it wrong then ;-)
I reckon you are right! Just re-copied and it works great. Thanks again!!!! :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks