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.
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.