I am working on a spreadsheet that will allow me to keep track of my savings
account. I have a set number ($600.00) that I need to place in my checking
per week that will cover my budget. When I work overtime, I would like to
place the difference into savings. Should be simple enough (the value in the
savings block should = the value entered into the wages block-600.00). Where
it becomes complicated for me is, sometimes I may fall under 600.00 wages.
This would create a negative number in the previous weeks savings block. When
I calculate it for the next week, I would like to be able to add back to the
checking the negative amount from the previous week before taking out for the
savings. I probably have lost you by now. Here is an example: Week 1 wages =
$540.00. This would show up as a -$40.00 to my savings account for week 1.
Week 2 wages = $700.00. This would show up as a $100.00 to my savings account
for week 2. Here is what I would like for this to do: Week 2 wages = $700.00
- $600.00 = $100.00 + - $40.00 = $60.00 to my savings account for week 2.
This tells me how much to transfer from checking to savings every week in
order to keep my $600.00 constant for my budget. It looks like I need an IF
statement with a value for true and a value for false. I can't seem to figure
out how to build the formula. Any HELP would be greatly appreciated. Thanks,
Rodney