Hi good afternoon.
I am doing money transfer business and i need to entry every transactions in excel to calculate the profit. But it takes a long time and need your help to make it better.
<tbody>
</tbody>
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
The first table i am entering 3 columns and fourth coloum (profit) need formula based on the second table.
Hope its clear and pls help for formula
I am doing money transfer business and i need to entry every transactions in excel to calculate the profit. But it takes a long time and need your help to make it better.
DATE | TDS | TRANSFER AMOUNT | PROFIT |
01/12/2018 | 2 | 5020 | 73 |
<tbody>
</tbody>
TRANSFER AMOUNT FROM 100 | TRANSFER AMOUNT TO 1015.3 | PROFIT 9 |
1015.4 | 1515.5 | 14.5 |
1515.6 | 2015.5 | 24.5 |
2015.6 | 2520 | 30 |
2520.1 | 3020 | 40 |
3020.1 | 3524.5 | 45.5 |
3524.6 | 4024.5 | 55.5 |
4024.6 | 4527 | 63 |
4527.1 | 5027 | 73 |
5027.1 | 6038.8 | 61.2 |
6038.9 | 7039 | 61 |
7039.1 | 8043.5 | 56.5 |
8043.6 | 9048 | 52 |
9048.1 | 1050 | 50 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
The first table i am entering 3 columns and fourth coloum (profit) need formula based on the second table.
Hope its clear and pls help for formula