Formula

[Guest]

I am balancing my checkbook and I have my starting balance, and in one field I enter if it was a Desposit or a Withdrawal, Is there a formula where I can enter Desposit or a Withdrawal in one field and my the amount I'm adding or Subtracting change my balance. I have it so that when I enter an amount, it subtracts that amount from the balance but is there a way to have one word mean subtract and one add, so it affects the balance in that way.

 

[Ragdyer]

One way:
Insert a column between your balance column and the column where you enter
the check amount (minus) and the deposit amount (plus)<Same Column>.

Format this column to Text.
For example, say this text column is E & balance is in column F & check
amount or deposit amount is column D.

Enter this formula in F2:
=IF(E2="+",F1+D2,F1-D2)

Now all you have to do when you make a deposit is enter the amount in column
D, and enter a + (plus sign) in column E and your balance will increase.
When you write a check and enter the amount in column D, it will be deducted
from your balance.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

I am balancing my checkbook and I have my starting balance, and in one

field I enter if it was a Desposit or a Withdrawal, Is there a formula where
I can enter Desposit or a Withdrawal in one field and my the amount I'm
adding or Subtracting change my balance. I have it so that when I enter an
amount, it subtracts that amount from the balance but is there a way to have
one word mean subtract and one add, so it affects the balance in that way.