View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GAM[_2_] GAM[_2_] is offline
external usenet poster
 
Posts: 1
Default 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