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
