Incremental decreases

[sergiurotaru]

Hello guys

Please help me with this question.

10000 10%
12500
15000
17500
20000
22500
25000 7%

Above I want to distribute percentages incremental, to decrease between 10%-7%. There is one formula for this.

Thanks

 

[Joe4]

Welcome to the Board!

You can use linear interpolation to do this. See: https://en.wikipedia.org/wiki/Linear_interpolation

So, if your data above was in cells A1:B7, so you are looking to populate cells B2:B6, place this formula in B2 and copy all the way down to B6:

=B$1+(A2-A$1)*(B$7-B$1)/(A$7-A$1)