Autosum automatically enters zero
 

I created a form that calculates a total in the right column. Every cell in
that column starts out with a "zero" in it until numbers are entered in the
other columns that need to be totaled. I want it blank until numbers are
entered and there is an actual result in the right column. How do I get rid
of the "zeros" in the total column on the right?

Autosum automatically enters zero
 

Maybe something like this:

=IF(COUNT(A1:D1),SUM(A1:D1),"")

--
Biff
Microsoft Excel MVP


"Sally" wrote:

I created a form that calculates a total in the right column. Every cell in
that column starts out with a "zero" in it until numbers are entered in the
other columns that need to be totaled. I want it blank until numbers are
entered and there is an actual result in the right column. How do I get rid
of the "zeros" in the total column on the right?

Autosum automatically enters zero
 

Hi,

1. Choose Tools, Options, View tab, and uncheck Zero values.

2. IF(H1,H1,"")
replace H1 with a formula if necessary. Its not clear from you question
what is in the other cells that the formula refer to (are they numbers, text
or formulas - if formulas show us one of them), nor is it clear what is
actually in the 0 cells - are they simple references or formulas.

3. Use conditional formatting to hide the 0's by changing the font color
(2003) or by using a custom format ;;; which hides the cell contents in 2007.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sally" wrote:

I created a form that calculates a total in the right column. Every cell in
that column starts out with a "zero" in it until numbers are entered in the
other columns that need to be totaled. I want it blank until numbers are
entered and there is an actual result in the right column. How do I get rid
of the "zeros" in the total column on the right?

Autosum automatically enters zero
 

I think we're on the right track but not quite there.

Columns A B C D E
# miles A*$.55 # meals C*$10 B+D

My formulas cause $0.00 to appear in all rows of B, D and E. I want them
blank unless there is a value higher than zero. All columns should be blank
until a number is entered in A or C.

thanks



"Shane Devenshire" wrote:

Hi,

1. Choose Tools, Options, View tab, and uncheck Zero values.

2. IF(H1,H1,"")
replace H1 with a formula if necessary. Its not clear from you question
what is in the other cells that the formula refer to (are they numbers, text
or formulas - if formulas show us one of them), nor is it clear what is
actually in the 0 cells - are they simple references or formulas.

3. Use conditional formatting to hide the 0's by changing the font color
(2003) or by using a custom format ;;; which hides the cell contents in 2007.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sally" wrote:

I created a form that calculates a total in the right column. Every cell in
that column starts out with a "zero" in it until numbers are entered in the
other columns that need to be totaled. I want it blank until numbers are
entered and there is an actual result in the right column. How do I get rid
of the "zeros" in the total column on the right?

Autosum automatically enters zero
 

Hi,

Replace the first formula with
=IF(A2,A2*0.55,"")
Replace the second formula with
=IF(C2,C2*10,"")
Replace the third formula with
=IF(OR(B2<"",D2<""),SUM(B2,D2),"")

copy these formulas down as far as you want.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sally" wrote:

I think we're on the right track but not quite there.

Columns A B C D E
# miles A*$.55 # meals C*$10 B+D

My formulas cause $0.00 to appear in all rows of B, D and E. I want them
blank unless there is a value higher than zero. All columns should be blank
until a number is entered in A or C.

thanks



"Shane Devenshire" wrote:

Hi,

1. Choose Tools, Options, View tab, and uncheck Zero values.

2. IF(H1,H1,"")
replace H1 with a formula if necessary. Its not clear from you question
what is in the other cells that the formula refer to (are they numbers, text
or formulas - if formulas show us one of them), nor is it clear what is
actually in the 0 cells - are they simple references or formulas.

3. Use conditional formatting to hide the 0's by changing the font color
(2003) or by using a custom format ;;; which hides the cell contents in 2007.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sally" wrote:

I created a form that calculates a total in the right column. Every cell in
that column starts out with a "zero" in it until numbers are entered in the
other columns that need to be totaled. I want it blank until numbers are
entered and there is an actual result in the right column. How do I get rid
of the "zeros" in the total column on the right?