My head is going around in circles on this simple task.
I am making a google spreadsheet (uses same functions as excel :)) to track my spending and try and budget.
Problem is as follows.
Current Balance: -£3.50
Overdraft Allowance: £2000
Remaining funds: I can work it out as thats 2000 - 3.50. Except I want excel to put the - before the 3.50 as its a negative balance, so excel is seeing it as 2000 - - 3.50 resulting in 2000 + 3.50
Meaning its giving remaining funds of 2003.50
How do I get around that?
Edit:
Dont worry... sorted it.
IF(MonthStartBalance<0,SUM((Overdraft+MonthStartBalance)+MonthExpend),SUM((Overdraft+MonthStartBal)-MonthExpend))
:)
The easy way to do it is if youre going to represent incomings and outgoing as + and - numbers, just =sum() the whole lot...
you should be adding youre current balance not taking it away ;)
so £2000 + -£3.50 = £1996.50
:)
yeah but my overdraft is listed as -£2000 :) lol so adding works :D
ahhhh, but that should be a +2000 ! :o
lol yeaaah but it just works :D