Thread: formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default formulas

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