Hi,
I am looking for a macro where I have a initial funds allowed to be used with the percentage I can get from until all the funds run out.
In fact, I want to know the total number of period to be used displayed until the balance is at zero.
For instance, if I have $800 to be used (J6) and 80% can be redeemed (J5) with an amount of 80$ declared (J17), then the period maximal to be used will be 13. For $1000 with 80% with $80 declared, 16 period can be used...
Here is how it looks like (if it was 800 with 80 declared ; 1000 with 80 declared):
Untitled-2.png
ss.png
Constraints
1. There will be a maximum of 24 periods (since maximum amount is 1500).
2. It must reflect the Percentage Allowed (J5) and Amount Redeemed (J17), so if I change value in those, it should work too.
Thanks
Claim.xlsx
Bookmarks