PLEASE help me with a simple budget formula!
 

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

--
GA
-----------------------------------------------------------------------
GAM's Profile: http://www.excelforum.com/member.php...fo&userid=2652
View this thread: http://www.excelforum.com/showthread.php?threadid=39795

PLEASE help me with a simple budget formula!
 

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"GAM" wrote in message ...

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 to
WITHDRAWL my car insurance if i enter it, and Put my new Account
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 Account
BALANCE to REFLECT that Deposit.. Basically Adjust the Account Balance
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 this
cell, Adjust,AND enter the Balance into a new cell for my account
balance


^ basically what i'm trying to do.. but i keep getting errors.. thank
youuuuuu


--
GAM
------------------------------------------------------------------------
GAM's Profile: http://www.excelforum.com/member.php...o&userid=26527
View this thread: http://www.excelforum.com/showthread...hreadid=397958

PLEASE help me with a simple budget formula!
 

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.


--
UofMoo
------------------------------------------------------------------------
UofMoo's Profile: http://www.excelforum.com/member.php...o&userid=26485
View this thread: http://www.excelforum.com/showthread...hreadid=397958