software

I'm looking for a formula that will return a blank cell if the value of
the reference cell is 0. I know that I can use conditional formatting
to turn the 0 the same color as the background but am hoping there is a
way to just return a blank cell since this might also be helpful in
other situations.
Example:
=IF(('.064quot;'!D28gt;0),B1*B2,0) will return 0 if reference cell
'.064quot;'!D28 is = 0. But what will return a blank cell?
Thanks--
pdgood
------------------------------------------------------------------------
pdgood's Profile: www.excelforum.com/member.php...oamp;userid=31623
View this thread: www.excelforum.com/showthread...hreadid=517960Display or hide all zero values on a worksheet

On the Tools menu, click Options, and then click the View tab.
Do one of the following:
To display zero (0) values in cells, select the Zero values check box.

To display zero values as blank cells, clear the check box.For more information, click on Help in Excel and under Index, type in
quot;Hidequot;. below it will show a category for quot;Display or Hide Zero valuesquot;.

Bob
quot;pdgoodquot; wrote:

gt;
gt; I'm looking for a formula that will return a blank cell if the value of
gt; the reference cell is 0. I know that I can use conditional formatting
gt; to turn the 0 the same color as the background but am hoping there is a
gt; way to just return a blank cell since this might also be helpful in
gt; other situations.
gt; Example:
gt; =IF(('.064quot;'!D28gt;0),B1*B2,0) will return 0 if reference cell
gt; '.064quot;'!D28 is = 0. But what will return a blank cell?
gt; Thanks
gt;
gt;
gt; --
gt; pdgood
gt; ------------------------------------------------------------------------
gt; pdgood's Profile: www.excelforum.com/member.php...oamp;userid=31623
gt; View this thread: www.excelforum.com/showthread...hreadid=517960
gt;
gt;

Hi,

=IF(('.064quot;'!D28gt;0),B1*B2,quot;quot;)

Regards,
B. R. Ramachandran

quot;pdgoodquot; wrote:

gt;
gt; I'm looking for a formula that will return a blank cell if the value of
gt; the reference cell is 0. I know that I can use conditional formatting
gt; to turn the 0 the same color as the background but am hoping there is a
gt; way to just return a blank cell since this might also be helpful in
gt; other situations.
gt; Example:
gt; =IF(('.064quot;'!D28gt;0),B1*B2,0) will return 0 if reference cell
gt; '.064quot;'!D28 is = 0. But what will return a blank cell?
gt; Thanks
gt;
gt;
gt; --
gt; pdgood
gt; ------------------------------------------------------------------------
gt; pdgood's Profile: www.excelforum.com/member.php...oamp;userid=31623
gt; View this thread: www.excelforum.com/showthread...hreadid=517960
gt;
gt;