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

Using IF, AND and OR functions together 2
Adding cells but leaving blank if not populated 2
Transfer data between two tables 3
HELP: IF Statement between Dates for Reverse Index failing 0
Newbie Help - IF Yes No Function 0
Nested if statements creating a blank cell 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Isblank error 3

Top