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

ahhhh, but that should be a +2000 !  

lol yeaaah but it just works