Blank cell if no value

L

Ltat42a

I have a spreadsheet in which I enter numbers in, then calculate a
certain range -
sum(f4:f10). The cell that contains this formula always shows 0 if
nothing is entered in this range. How can I edit this forumla that will
display nothing in the cell if nothing is entered, if something is
entered, then it will display the sum

Any suggestions?
 
S

swatsp0p

Hi, Ltat. You have two options.

1) Tools>Options | View tab>uncheck Zero Values in the Window options
section
note that this will affect ALL cells that have a zero value

2) Use an IF formula, as such:

=IF(sum(f4:f10)=0,"",sum(f4:f10))

A blank cell will be displayed if the sum is zero, else the sum will be
displayed.

HTH

Bruce
 
L

Ltat42a

swatsp0p said:
Hi, Ltat. You have two options.

1) Tools>Options | View tab>uncheck Zero Values in the Window options
section
note that this will affect ALL cells that have a zero value

2) Use an IF formula, as such:

=IF(sum(f4:f10)=0,"",sum(f4:f10))

A blank cell will be displayed if the sum is zero, else the sum will be
displayed.

HTH

Bruce
Click to expand...


Perfect! - Thanx!
 
L

Ltat42a

swatsp0p said:
Glad it worked for you. Feedback is always appreciated. Which option
did you use?

Cheers!

Bruce
Click to expand...

#1 -
Tools>Options | View tab>uncheck Zero Values in the Window options
section
note that this will affect ALL cells that have a zero value
 
Top