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(('.064"'!D280),B1*B2,0) will return 0 if reference cell
'.064"'!D28 is = 0. But what will return a blank cell?
Thanks


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=517960

Display 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
"Hide". below it will show a category for "Display or Hide Zero values".

Bob



"pdgood" wrote:


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(('.064"'!D280),B1*B2,0) will return 0 if reference cell
'.064"'!D28 is = 0. But what will return a blank cell?
Thanks


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=517960

Hi,

=IF(('.064"'!D280),B1*B2,"")

Regards,
B. R. Ramachandran

"pdgood" wrote:


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(('.064"'!D280),B1*B2,0) will return 0 if reference cell
'.064"'!D28 is = 0. But what will return a blank cell?
Thanks


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=517960