Returning blanks in an IF formula

Contributor

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.75,"Medium",IF(B2<3.75,"Low",IF(B2="",""))))/...clearly the last IF was to control the blanks issue but didnt happen

 

Conditions inputted work fine till you get to blank cell then it returns LOW in column A still. I will rather have it return a blank cell in A if corresponding cell is also blank.

 

Any ideas on that?

 

THanks and enjoy your Sunday

 

NoviceKB

2 Replies

@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

@NoviceKB 

As variant

=XLOOKUP(B2, {-100,3.75,4.75,""},{"Low","Medium","High",""},,-1)