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 10544 Posts Monday June 3, 2013Registration dateModeratorStatus September 25, 2018 Last seen - Jan 11, 2016 at 07:09 PM
0
Thank you
Well, it is like this:
=a1-b1

In cell c1.

So, in cell c1 use the above formula. Then in a1 use the credit amount. IN b1 use the debit amount.
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
0
Thank you
Solved myself
Many thanks