=IF(A1=0,"",A1+A2)
--
Gary''s Student


"duugg" wrote:


I have a spreadsheet set up and would like to hide the value of a
formula if one cell has a zero value.

for example...

A1, value is 0
A2, value is 22

A3 (formula) is A1 + A2

But if A1 is zero, I want A3 to show nothing, how do I do this?

thanks in advance


--
duugg
------------------------------------------------------------------------
duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=531995