Return blank cell if data cell is blank
 

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.

Return blank cell if data cell is blank
 

=IF(I5="","",yourformula)
--
Gary''s Student - gsnu200903

Return blank cell if data cell is blank
 

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


"imckinne" wrote in message
...
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.

Return blank cell if data cell is blank
 

You can create a null sting with "", ie nothing in a pair of double
quotes.

On Sep 15, 11:10*am, imckinne
wrote:
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.

Return blank cell if data cell is blank
 

PERFECT! THank you!

"Gary''s Student" wrote:

=IF(I5="","",yourformula)
--
Gary''s Student - gsnu200903