Formula that will leave cell blank if cell is blank

J

jimtmcdaniels

I have a formula adding & subtracting the number values in 3 different cells
into a fourth cell, however I need to change the formula so that if one of
the cells is blank, the fourth cell sum will show blank too.

I think a simple IF formula will work, but I don't know how to tell the
formula if the cell is blank.

example: A1 =Sum(A2-A3+A4)

I've tried something like: IF(A2=blank,"",sum(A2-A3+A4)
but I get an error.
 
K

K Dales

blank cells are equal to a zero length string:
=IF(A2="","",A2-A3+A4)
(note: the SUM function was redundant, here)
Another way, if you want to check all three cells, recognizing that COUNT
only counts numbers:
=IF(COUNT(A2:A4)<3,"",A2-A3+A4)
 

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

Top