Empty Cell

[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

 

[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

 

[Jeff Mackeny]

thanks

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