Report

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

Ask a question Jack - Last answered on Jan 13, 2016 04:51AM
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 
Helpful
+4
moins plus
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.
Jack- Jan 12, 2016 09:37AM
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.
Reply
Jackthelad- Jan 13, 2016 04:51AM
The question was 3 columns with the total of either first 2 columns in the 3rd column, but have resolved myself, but many thanks
Reply
Add comment
Helpful
+4
moins plus
Solved myself
Many thanks
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!