excel formula

Occasional Visitor

i want to create a formula for my house hold budget. i want it to work in these columns

income      outgoings       balance

eg

income  =A1+A3 being the balance

outgoings  =A2-A3 being balance

i want to be able to put in my income on a weekly basis

then i want to put in my outgoings on a weekly basis

i want to have a rolling balance as the money goes in and comes out 

i just cant get my head around setting it up

any help would be great thank you

 

1 Reply

@strwbe 

You may use formula as here

image.png

but better to transform your data in structured table as on the right, with that it will be expanded automatically. Formula is

=N(CellUp)+[@income]-[@outgoings]

where CellUp is the named reference as

image.png