Trying to combine an ISBLANK function with a Nested string IF formula

[Florida1510]

Folks,

I need some education for some reason I can get the ISBLAN function to work with my Nested string IF formula. I need to be able to have the formula in the cell preloaded but the need the results to show nothing. Right now without the ISBLANK the field populates with a 1. Any help would be really appreciated. Thanks in advance.

Current formula that gives me the "1" - =IF(F27<=7,"1",IF(AND(F27>7,F27<=14),"2",IF(AND(F27>14,F27<=21),"3","4")))
Formula that I'm trying to get to work to show the blank - =IF(ISBLANK(F27),"",IF(AND(F27<=7,"1",IF(AND(F27>7,F27<=14),"2",IF(AND(F27>14,F27<=21),"3","4"))))

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(F27="","",IF(F27<=7,"1",IF(F27<=14,"2",IF(F27<=21,"3","4"))))

 

[Florida1510]

Thank you so much I truly appreciate the assistance here you made my day. Thanks again!!!!!!!

 

[Fluff]

You're welcome & thanks for the feedback