Jack -
Jan 11, 2016 at 09:09 AM - Latest reply: Jackthelad
- Jan 13, 2016 at 04:51 AM

- Formula if you have credit in one column, debit in next column
- Find missing data in 2 columns (Excel) » Forum - Excel
- Formula to count if cells in consecutive columns are populated » Forum - Excel
- Excel formula to compare two columns and return a value (Solved) » Forum - Excel
- Vlookup formula to compare two columns in different sheets » How-To - Excel
- Excel formula to compare two columns and return a value » Forum - Excel

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.

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

Was this answer helpful? Yes No

Report

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.

Report

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.