how to skip empty cells

[evalam]

33	K
60	L
	K
77	L
68	J

<tbody>
</tbody>

HI everyone i am using this formula =IF(D4>70; "J"; IF(D4<50;"K";"L")). Do you have any suggestions what to do with the empty shell?i have the letter K appear when what i want is to jump the empty cell.

 

[Jonmo1]

You could do

=IF(D4="";"";IF(D4>70; "J"; IF(D4<50;"K";"L")))

 

[ghrain22]

just nest an additiona if formula with an isblank function or alternatively =""

If(isblank(d4),"",IF(D4>70, "J", IF(D4<50,"K","L")))

 

[John Davis]

Maybe:

=IF(D4<>"",IF(D4>70,"J",IF(D4<50,"K","L")),"")

 

[evalam]

Thank you i am new in excel and i m getting lost from time to time