Empty Cell

J

Jeff Mackeny

quick question, if I have the following formula =G4-D4-E4-H4 and the results
is 0, how to keep the cell blank Vs the cell saying 0
 
J

JulieD

Hi Jeff

two options
tools / options / view tab - untick zero values

or for only specific cells (and my preferred method)
=if(G4-D4-E4-H4=0,"",G4-D4-E4-H4)

Cheers
JulieD
 
J

Jeff Mackeny

thanks
JulieD said:
Hi Jeff

two options
tools / options / view tab - untick zero values

or for only specific cells (and my preferred method)
=if(G4-D4-E4-H4=0,"",G4-D4-E4-H4)

Cheers
JulieD
Click to expand...
 
Top