- Formula if you have credit in one column, debit in next column
- Conditional formating - apply on more cells [Solved] (Solved)
- Formula to count if cells in consecutive columns are populated
- Excel – Formula to calculate between two columns
- Excel - Formula to get sum of debit/credit in another sheet
- Need a formula to sum a column with #Value error (Solved)

Solved myself

Many thanks

Many thanks

Was this answer helpful?

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.

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

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.