Hi,
I’m quite new to spreadsheets in LibreOffice (and in general) to manage my finances. I’ve been trying to calculate things but it’s getting confusing as I’d much prefer to enter a total balance amount and then whenever I make an expenditure anywhere (be it withdraw from ATM or online etc.) I’d like the sheet to deduct that amount from the total amount so I can visbly see the current balance at all times.
Before anyone says ‘just check your bank account’ this is not always accurate as things don’t always process immediately and I’ve found writing things down the moment you purchase them is the most suitable and manageable way of doing things.
So, basically, if I have a total balance of £3000 and I spend £100 on something, I want the cell with the £3000 to read £2900. Is there a way to do this using the equation function? If so, how would I write it?
Thank you