I have a debit and a credit column. If one cell in debit is lager than a cell in credit than I would like excel to calculate the difference and add the difference in a cell in the correct row.
For example:
Column A Column B
====== ======
Debit Credit
299,9 300
0,1
Column B contain 10 cent more than column A.
Excel shall then add 0,1 in a cell below 299,9.
If Column A would contain a larger sum then excel should add the difference to the cell below column b. The row will be fixed. All excel have to do is to know what column to add the difference in.
Thanks in advance
Mr_GZ
For example:
Column A Column B
====== ======
Debit Credit
299,9 300
0,1
Column B contain 10 cent more than column A.
Excel shall then add 0,1 in a cell below 299,9.
If Column A would contain a larger sum then excel should add the difference to the cell below column b. The row will be fixed. All excel have to do is to know what column to add the difference in.
Thanks in advance
Mr_GZ