Hi everybody !
In the attached workbook, in W8, I have a formula that allows me to smooth a sum between a start date and an end date.
I also apply a weighting coefficient to this formula.
If I change a coefficient, all the sums change and are updated, this is normal!
I want to modify my formula so that the sums do not move before the cell affected by the weighting coefficient.
You will find an example with explanation in the attached workbook.
Thank you for sharing your ideas and solutions.
AL 22
In the attached workbook, in W8, I have a formula that allows me to smooth a sum between a start date and an end date.
I also apply a weighting coefficient to this formula.
If I change a coefficient, all the sums change and are updated, this is normal!
I want to modify my formula so that the sums do not move before the cell affected by the weighting coefficient.
You will find an example with explanation in the attached workbook.
Thank you for sharing your ideas and solutions.
AL 22