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(A11),SUM(A11),"")

--
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?