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