Thread
:
formulas
View Single Post
#
3
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_]
external usenet poster
Posts: 3,346
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
Reply With Quote
Shane Devenshire[_2_]
View Public Profile
Find all posts by Shane Devenshire[_2_]