Return blank cell if data cell is blank

  • Thread starter Thread starter imckinne
  • Start date Start date
I

imckinne

I'm using a nested IF formula but want empty cells to return an empty cell.
Here is an example of the formula I am using:

=IF(I5>=40,"Low RIsk",IF(I5>=20,"Some Risk",IF(I5<=19,"At Risk")))

When, in this case I5 is a bank cell, it is returning "at risk" as the
value. I want a blank cell returned without having to delete the formula so
that data can be inputting at a later time.
 
=IF(I5>=40,"Low RIsk",IF(I5>=20,"Some Risk",IF(I5="","",IF(I5<=19,"At
Risk","Whatever value you want for I5 above 19 and below 20"))))
or you may have intended
=IF(I5>=40,"Low Risk",IF(I5>=20,"Some Risk",IF(I5="","","At Risk")))
 
Back
Top