Forum Discussion
Returning blanks in an IF formula
I am trying to enhance my formula to return blanks if there is no value entered in the "My Score" column(please see attached test file). My formula in column A2 is =IF(B2>=4.75,"High",IF(B2>=3....
NoviceKB Try it this way:
=IF(ISBLANK(B2),"",IF(B2>=4.75,"High",IF(B2>=3.75,"Medium",IF(B2<3.75,"Low"))))
Your original formula never gets past the "Lower" test as a blank cell is also less the 3.75