software

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: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=531995

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

quot;duuggquot; wrote:

gt;
gt; I have a spreadsheet set up and would like to hide the value of a
gt; formula if one cell has a zero value.
gt;
gt; for example...
gt;
gt; A1, value is 0
gt; A2, value is 22
gt;
gt; A3 (formula) is A1 A2
gt;
gt; But if A1 is zero, I want A3 to show nothing, how do I do this?
gt;
gt; thanks in advance
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=531995
gt;
gt;

=IF(A1=0,quot;quot;,A1 A2)
--
Gary''s Studentquot;duuggquot; wrote:

gt;
gt; I have a spreadsheet set up and would like to hide the value of a
gt; formula if one cell has a zero value.
gt;
gt; for example...
gt;
gt; A1, value is 0
gt; A2, value is 22
gt;
gt; A3 (formula) is A1 A2
gt;
gt; But if A1 is zero, I want A3 to show nothing, how do I do this?
gt;
gt; thanks in advance
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=531995
gt;
gt;

You could probably use an if statement :
=if(A1=0,quot;quot;,A1 A2)

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

Neda

quot;duuggquot; wrote:

gt;
gt; I have a spreadsheet set up and would like to hide the value of a
gt; formula if one cell has a zero value.
gt;
gt; for example...
gt;
gt; A1, value is 0
gt; A2, value is 22
gt;
gt; A3 (formula) is A1 A2
gt;
gt; But if A1 is zero, I want A3 to show nothing, how do I do this?
gt;
gt; thanks in advance
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=531995
gt;
gt;

Hi,
In A3,

=IF(A1=0,quot;quot;,A1 A2)

Regards,
Bondi
If I'm using this formula...

=IF(F24=quot;quot;,quot;quot;,F22 F24)

In cell F26and this formula

=IF(F20=quot;quot;,quot;quot;,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?--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=531995