Return blank cell if data cell is blank

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.
 
D

David Biddulph

=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")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding cells but leaving blank if not populated 1
values not showing for copied formulas 2
Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
Isblank error 3
Offset, sum down to the first blank row 6
IF statement with 3 possible outcomes 2
How do I get an IS and IF statement to work together in excel? 3
Need data entered to reflect hh:mm format 3

Top