Making a 0 in a cell appear as a blank cell instead

S

suee

I have the following function
=IF(ISERROR(((C4/1000)*(D4/1000))*E4),"",((C4/1000)*(D4/1000))*E4)...
These cells are formatted to general.
These cells leave a 0 once data is entered then deleted. I would lik
these cells if they contain a 0, to display a blan cell instead.
Anyone know how i would do this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Condition 4
making a 0 in a cell appear blank 2
Leave final cell blank 2
The sum of the same function that is used for a range of cells 2
change cell color depending on two cell values 1
Filter with an IF, AND, NOT formula 1
Calculation using IF 6
Calculation using IF 1

Top