How to hide unused cells when running accumulated totals

I am running 2 columns to do accumulated totals. I have a formula such as
this: Cell b2 = a2+b1,
Cell c2 = b2+c1 ect.
I want to hide the accumulated totals until the cell in column one gets a
value. How can I accomplish this?
Thanks
grano2

Hi

Instead of =A2+B1, use =IF(A2="","",A2+B1) B2+C1 will change to

=IF(B2="","",B2+C1)

--
j.kasselman@atlantic.net.remove_2nd_at. Randburg, Gauteng, South Africa


"grano2" wrote:

> I am running 2 columns to do accumulated totals. I have a formula such as
> this: Cell b2 = a2+b1,
> Cell c2 = b2+c1 ect.
> I want to hide the accumulated totals until the cell in column one gets a
> value. How can I accomplish this?
> Thanks
> grano2

Hi

Instead of =A2+B1, use =IF(A2="","",A2+B1) B2+C1 will change to

=IF(B2="","",B2+C1)

--
j.kasselman@atlantic.net.remove_2nd_at. Randburg, Gauteng, South Africa


"grano2" wrote:

> I am running 2 columns to do accumulated totals. I have a formula such as
> this: Cell b2 = a2+b1,
> Cell c2 = b2+c1 ect.
> I want to hide the accumulated totals until the cell in column one gets a
> value. How can I accomplish this?
> Thanks
> grano2

Hi

Instead of =A2+B1, use =IF(A2="","",A2+B1) B2+C1 will change to

=IF(B2="","",B2+C1)

--
j.kasselman@atlantic.net.remove_2nd_at. Randburg, Gauteng, South Africa


"grano2" wrote:

> I am running 2 columns to do accumulated totals. I have a formula such as
> this: Cell b2 = a2+b1,
> Cell c2 = b2+c1 ect.
> I want to hide the accumulated totals until the cell in column one gets a
> value. How can I accomplish this?
> Thanks
> grano2