Hiding the value of a formula if 1 cell has a value of zero.

[duugg]

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

[Toppers]

=if(A1=0,0,A1+A2)

"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
>
>

[Gary''s Student]

=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
>
>

[neda5]

You could probably use an if statement :
=if(A1=0,"",A1+A2)

or you could use conditional formatting, depending on what you want to do
exactly.

Neda

"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
>
>

[Bondi]

Hi,
In A3,

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

Regards,
Bondi

[duugg]

If I'm using this formula...

=IF(F24="","",F22+F24)

In cell F26


and this formula

=IF(F20="","",F18+F20)

is in cell F22

and

1

is in cell F24

I got a #value! error

Why is this the case when there is indeed a number 1 in cell F24?