PLEASE help me with a simple budget formula!

[GAM]

I'm trying to create a simple budget formula for microsoft excel.

[image: http://files.dmusic.com/music/g/a/ga/help-new.jpg]

Now.. Lets say i have $800 in E3.

I want to add my car insurance payment, which would go into D3.

I need a formula to automatically adjust my Account Balance t
WITHDRAWL my car insurance if i enter it, and Put my new Accoun
Balance into E4.

BUT.. here's the other thing..

I need the same thing for Deposits, or ADDING money..

Lets say i make a deposit of $950 into cell C6. I want my Accoun
BALANCE to REFLECT that Deposit.. Basically Adjust the Account Balanc
to match my deposits and withdrawls..

[image: http://files.dmusic.com/music/g/a/ga/help2-new.jpg]
^ Diagram of a basic Spreadsheet i wanna make..

PLEASE, if anyone can help, let me know..

And.. remember.. i wanna make the formual adjust accordingly..

maybe something like an =IF such and such amount is added to thi
cell, Adjust,AND enter the Balance into a new cell for my accoun
balance


^ basically what i'm trying to do.. but i keep getting errors.. than
youuuuu

 

[David McRitchie]

You left out check #; otherwise, the examples in
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
matches what you indicate.

 

[UofMoo]

In E4 type
= $E3+$C4-$D4
then copy this formula down the account balance column.
as long as there is the initial account balance in E3, it'll work.