- Formula if you have credit in one column, debit in next column
- 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)
- Formula that searches in a row for a cell/column that contains (Solved)

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.

Solved myself

Many thanks

Many thanks

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Jack- Jan 12, 2016 09:37AMJackthelad- Jan 13, 2016 04:51AM