Removing 0 and have a blank cell

B

brutium

Joined
Feb 28, 2012
Messages
5
Reaction score
0
I am in the process of cleaning up a workbook I created, and I am trying to change all the 0% cells with a blank cell.
I have a number of cells that get their value from other sheets, and I would like to avoid showing 0% when these should not have any values until these are inserted in the other sheets. How do I get the blank cell if I have this formula:

HTML: 
IFERROR(#REF!,"")


where "#REF!" is one of the other sheets.
 
you could try the following:
=IF((InsertMathHere)=0,"",(InsertMathHere))

And just put the division in for InsertMathHere. That should show a blank cell for any math that equals zero, or display the result if it doesn't.

Enjoy!
 
Back
Top