I need to split a value into decreasing amounts where I know the start and end values and the number of steps to do it in.
How can I calculate this? I have tried applying Arithmetic Sequence formulae, but because I know so many fixed values they don't work. Any ideas?
My example data is:
Start value D=5
Number of steps N=6
First step S1=1
Last step Sn=0.5
How can I calculate the size of the 4 steps that fit between the first and last step?

MENU