blank cell + blank cell = 0
=IF(A1+B1=0,"",A1+B1)

What if:

A1 = 5
B1 = -5

If the OP only wants a blank returned when *both* cells are empty:

=IF(COUNT(A1:B1)=0,"",A1+B1)

Or, to be more robust:

=IF(COUNT(A1:B1)=0,"",SUM(A1:B1))

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
Hi,

Try

=IF(A1+B1=0,"",A1+B1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sandi" wrote:

What kind of formula do I use for:

blank cell + blank cell = 0 how do I get it to not show if the value is
0?
--
Sandi