I have a budget column called E2 with $20k, I have a balance column called G2
which is where I want the decreasing balance to show using the correct
formula. I need the other colums following to keep subtracting as entries are
made to reduce the balance column. I think I am close, but not close enough -
can anyone help?

Im putting in G2 the following formula
=E2-H2,E2-I2,E2-J2,E2-K2,E2-L2,E2-M2,E2-N2,E2-O2,E2-P2,E2-Q2,E2-R2

One way:

G2: =E2-SUM(H2:R2)

In article ,
skitten wrote:

I have a budget column called E2 with $20k, I have a balance column called G2
which is where I want the decreasing balance to show using the correct
formula. I need the other colums following to keep subtracting as entries are
made to reduce the balance column. I think I am close, but not close enough -
can anyone help?

Im putting in G2 the following formula
=E2-H2,E2-I2,E2-J2,E2-K2,E2-L2,E2-M2,E2-N2,E2-O2,E2-P2,E2-Q2,E2-R2

hi
this might work better.
=E2-SUM(H2:R2)

regards
FSt1

"skitten" wrote:

I have a budget column called E2 with $20k, I have a balance column called G2
which is where I want the decreasing balance to show using the correct
formula. I need the other colums following to keep subtracting as entries are
made to reduce the balance column. I think I am close, but not close enough -
can anyone help?

Im putting in G2 the following formula
=E2-H2,E2-I2,E2-J2,E2-K2,E2-L2,E2-M2,E2-N2,E2-O2,E2-P2,E2-Q2,E2-R2