• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF formula: need help creating the formula

Smitty15

New Member
Column B is text either "Credit" or "Debit"

Column D is number

Column E is running balance


I want an "if" statement to this effect: If Column B = Credit then "Add" Column D to Column E, but If Column B = Debit then "Subtract" Columnd D from Column E.


This would be a running tally as entries are made. Any idea how I can do this? Thanks in advance.
 
Smitty

Give this a go in E3

Code:
=E2+IF(B3="Credit",D3,-D3)

Copy down as appropriate
 
Back
Top