bjannseniu
New Member
- Joined
- Jun 25, 2014
- Messages
- 16
I am calculating a payback period (savings - expense) on a weekly basis. I am aggregating savings and expenses each week and at some point in time, my aggregate savings > aggregate expenses. The payback period only happens once, when the aggregate savings > aggregate expenses. I would like to choose that week automatically. My example table is below, I'm looking for a formula to populate the Payback Period column as the below example:
<colgroup><col width="56" style="width: 42pt;"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2858;" span="5"> <tbody>
</tbody>
Weekly | Weekly | Aggregate | Aggregate | Payback | |
Week | Expense | Savings | Expense | Savings | Period |
1 | $ 1,000 | $ 100 | $ 1,000 | $ 100 | |
2 | $ 500 | $ 300 | $ 1,500 | $ 400 | |
3 | $ - | $ 600 | $ 1,500 | $ 1,000 | |
4 | $ - | $ 800 | $ 1,500 | $ 1,800 | 4 |
5 | $ - | $ 900 | $ 1,500 | $ 2,700 | 4 |
6 | $ - | $ 1,000 | $ 1,500 | $ 3,700 | 4 |
<colgroup><col width="56" style="width: 42pt;"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2858;" span="5"> <tbody>
</tbody>