How to return a blank cell if sum = 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I show a blank cell, instead of the number 0 in the cell, if the
formula in that cell results in an answer of 0?
 
=If(myformula=0,"",myformula), say, +if(sum(A3:g3)=0,"",Sum(a3:g3))

Peter
 
How would I show a blank cell, instead of the number 0 in the cell,
if the formula in that cell results in an answer of 0?
Click to expand...

Another option... if you want zero values to not show **anywhere** on your
worksheet, you can turn them off globally for the worksheet in question. If
you have more than one worksheet, make sure the one you want to turn zeroes
off in is active. Click Tools/Options on Excel's menu bar, select the View
tab from the dialog box and uncheck the Zero Values option in the Window
Options section.

Rick
 
Custom format General;-General;

will not display a zero

apply the same method if you have currency, number formats etc
 
You must log in or register to reply here.

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

Excel formula, sum the value cell and if empty cell left blank 0
balnk is no text or formula exist in reffering cell 3
Averageifs - criteria is cell is not blank 1
SUM / COUNT formula 3
Ignoring Blank cells 9
How to set cell value to emptry if three other columns are empty too 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Excel Need Countifs Formula Help 0

Back
Top