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

  • 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
 
Back
Top