Removing "Blank" Result from cell

[MARIE15]

I am using a formula in which the results "low", "medium, or "high" will appear (in column U) based on the numerical value that is entered in another cell (in column T).

=IF(T3<>"",IF(T3<=59,"LOW",IF(T3<=79,"MEDIUM",IF(T3>=79,"HIGH",""))))

It works perfectly, however the word "FALSE" is shown in all the empty cells in column U, wherever data has not yet been entered in Column T.

I would like to have the cells in column U remain blank when data has not yet been entered, rather than having the word "FALSE" appear.

Any help would be greatly appreciated.

 

[Joe4]

Welcome to the Board!

You just forgot to address the FALSE argument of your initial IF.
Try:

=IF(T3<>"",IF(T3<=59,"LOW",IF(T3<=79,"MEDIUM",IF(T3>=79,"HIGH",""))),"")

 

[MARIE15]

It worked! Thank you so much! :D

 

[Joe4]

You are welcome!

Whenever you get an unexpected "FALSE" with an IF formula, it means that you have a FALSE clause that has not been populated (so it defaults to FALSE).

 

[MARIE15]

I knew that was the problem, but didn't now how to correct the formula. I tried so many different variations without success. Thank you again!

 

[Joe4]

You are welcome.

In these cases, it is often best to start off when a single IF, and then build upon that.

Or sometimes it makes sense to start the other way (i.e. what to do if it IS blank):

=IF(T3="","",...)