Excel Formula....Simple?

stokes

stokes

Messages
3,113
Name
Tom
Edit My Images
Yes
Okay guys. Anyone any good at excel formula?

Im trying to create what i think should be a simple formula.

Im trying to get my table to be clever.

Untitled-1.jpg



Say i make another deposit of £50, i want Cell F to automatically calculate the current balance based upon Cell e (the amount) and the type (deposit or debit)

So if i made a Deposit, it would add the £50 to the balance, and if i made a debit, it would reduce to the balance by £50.
Does that make sense?

Any ideas?
 
Last edited:
i'd simply remove the 'Type' column and give the debits a negative value :shrug:
 
In cell F10 copy the following equation

=IF(D10="Deposit",F9+E10,IF(D10="Debit",F9-E10,""))

Then copy this into the cells below F10 and bob's your uncle
 
ignore me :bonk:
 
Last edited:
Glad it's sorted, but I would recommend that you give deposits a positive value and debits a negative value. You can still have the 'type' column that can automatically write in whether it is a deposit or a debit (and colour code them red or green) so you don't lose any functionality.
Doing this would keep the conditional statements out of the calculations, which IMO is a neater solution and less likely to give any errors in future when you need to use those figures for more complicated calculations.
 
You must log in or register to reply here.
Back
Top