making a 0 in a cell appear blank

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
 
H

HKBigB

If you really don't want to show 0 on your spreadsheet, you need to pu
one more "IF", so it won't show 0 anymore.


=IF(IF(ISERROR(((C4/1000)*(D4/1000))*E4),"",((C4/1000)*(D4/1000))*E4)=0,"",IF(ISERROR(((C4/1000)*(D4/1000))*E4),"",((C4/1000)*(D4/1000))*E4))

Hopefully, it can solve your problem
 

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 as a blank cell instead 1
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