making a 0 in a cell appear blank

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