Forum Discussion
Formula Assist
Dears,
Kindly need your usual support to assist with a formula to calculate collection of bounced to be 30 % from total bounced (ex. For collection of bounced feb =total bounced Feb*30% and for march total bounced feb+ total bounced of march *30% till consume total bounced feb) as per the attached sample.
Thanks in advance
You started out correctly - see the attached version.
6 Replies
Try this:
Let's assume you have the following data:
- Column A: Month
- Column B: Total Bounced
- Column C: Collection
Here’s a step-by-step formula for the calculation:
1. February Collection:
-
- Formula in cell C2:
=B2*0.32. March Collection:
-
- Formula in cell C3:
=(B2 + B3)*0.33. April Collection and beyond:
-
- For each subsequent month, you need to add the previous month's total bounced to the current month's total bounced and then multiply by 30%.
- Formula in cell C4:
=(SUM($B$2:B4))*0.3Your question mentions 30% but the formulas in your workbook use 35% (initially). Please explain.
Thank you Mr. Hans for your reply, its a typo Mistake the correct is 35%
You started out correctly - see the attached version.
