formula help

[rd]

I'm trying to create a "balance" formula that will take
an expense from the expense cell and have it subtract it
from the "account balance" OR if it's an income credit
from the credit amount cell, it will add that to the
account balance column. And if that's not over my head,
there is a column where an amount is removed from the
balance to pay a person - this isn't an expense exactly
as the balance belongs to that person - it's a removal of
an amount from the balance to put in his pocket.

Let's assume that C4 is an expense; D4 is income; and E4
is the "pay" amount. F4 is the account balance. IF C4
is a $ then F4= F3-C4; but IF D4 is a $, then F4=F3+D4;
but if E4 is $ then F4=F3-E4. Does that make sense and
if it makes sense - how do I put that all together in In
F4 so that it will work.

Quick admission - I was terrible in school with these
things and if I was going to do the calculation each time
with a pencil - it would be much easier. Thanks.

 

[Jason Morin]

It seems that F4 should be:

=F3-C4+D4

which is reads as:

New balance = old balance - expense + income credit

Then you should be to just copy this formula down teh
column.

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks Jason, I'll try that - I guess I was trying to
make it more complicated than it is. rd