Empty Cell

  • Thread starter Thread starter Jeff Mackeny
  • Start date Start date
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
 
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
 
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...
 

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

Leave final cell blank 2
Combining two functions 13
ISBLANK IF STATEMENT 6
Empty Cell 4
Function Help 3
if statement 1
iserror 4
how to undo scrolling tied to a single cell 1

Back
Top