Previous Topic Next Topic

Formula if you have credit in one column, debit in next column

Solved/Closed
Jack - Jan 11, 2016 at 09:09 AM
 Jackthelad - Jan 13, 2016 at 04:51 AM
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



2 responses

Answer 1 / 2
Blocked Profile
Jan 11, 2016 at 07:09 PM
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

Similar discussions

script which can check if a debit has a corresponding credit
dennisvhansen -
dennisvhansen -

11 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Excel - To generate unique ID
wliang -
ferg -

4 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Counting number of times a value appears if..
jensorr -
sambr22 -

7 responses