Jun 07 2021 09:42 PM
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
Jun 08 2021 12:33 AM
You may use formula as here
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