Returning a blank field

  • Thread starter Thread starter pdgood
  • Start date Start date
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
 
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
 
Back
Top