Forum Discussion
Solved
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 marc...
You started out correctly - see the attached version.
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.3
2. March Collection:
-
- Formula in cell C3:
=(B2 + B3)*0.3
3. 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.3