Report

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

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

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!