Formula if you have credit in one column, debit in next column [Solved/Closed]

Jack - Jan 11, 2016 at 09:09 AM - Latest reply:  Jackthelad
- Jan 13, 2016 at 04:51 AM
Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column.
Many thanks
R Horner

See more 

4 replies

ac3mark 9220 Posts Monday June 3, 2013Registration dateModeratorStatus April 25, 2018 Last seen - Jan 11, 2016 at 07:09 PM
Well, it is like this:

In cell c1.

So, in cell c1 use the above formula. Then in a1 use the credit amount. IN b1 use the debit amount.
Was this answer helpful?  
The question was regarding 3 columns credit in first, debit in the second and balance in the third, the same as in a bank statement. It is the formula for all three columns I need.
The question was 3 columns with the total of either first 2 columns in the 3rd column, but have resolved myself, but many thanks
jackthelad 1 Posts Tuesday January 12, 2016Registration date January 12, 2016 Last seen - Jan 12, 2016 at 09:53 AM
Solved myself
Many thanks