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