malkiq_buda
New Member
- Joined
- Oct 16, 2012
- Messages
- 8
Employees of my company take advances payments for travel or other business expenses and after that they should be refunded. As seen at some point the amount in column one is approximately equal to or equal to zero. I need when the sum in column 2 is equal to 0 to have a new calculation from the next line till I get 0 again. If the sum of row 1 to 3 to is zero, I need the formula to start next calculation from row 4 till it`s zero again and again. Thanks for help in advance.
<colgroup><col width="88" span="2" style="width:66pt"> </colgroup><tbody>
</tbody>
Total Amount | |
1,000.00 | |
-800 | |
-200 | 0.00 |
-39.96 | |
-12.99 | |
-15.83 | |
-162.9 | |
-117.35 | |
-4,352.76 | |
-996.95 | |
-2,284.06 | |
231.68 | |
7,751.11 | -0.01 |
2,500.00 | |
-2,007.26 | |
-50 | |
-4.54 | |
2,057.26 | |
-957.36 | |
-169.96 | |
-369.75 | |
-323.4 | |
-105.5 | |
-114.46 | |
-155.61 | |
-97.2 | |
-386.77 | |
184 | |
-50 | |
-327.8 | |
-801.2 | |
-60.99 | |
-612.59 | |
862.75 | |
327.8 | |
612.59 | |
-466.84 | |
-437.07 | |
50 | |
-50 | |
50 | |
903.91 | 0.01 |
-50 | |
-50 | |
-29.34 | |
-842.08 | |
-615.46 | |
-50 | |
-155.1 | |
-345.95 | |
920.56 | |
1,217.37 | 0.00 |
<colgroup><col width="88" span="2" style="width:66pt"> </colgroup><tbody>
</tbody>