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?

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?

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?

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?

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?