I need to solve for the values between two values. The values need to grow sequentially from the Starting Point A1 to the new value in F1

A1 = 10

F1 = 20

need to solve for B1, C1, D1, and E1 - growth is sequential from A1 to E1

i.e.  B1 = 12, C1 = 14, D1 = 16, E1 = 18

Thanks jack

In B1, enter the formula

=A1+($F$1-$A$1)/(COLUMNS($A$1:$F$1)-1)

and copy to C1:E1.

You can change the values in A1 and F1, and add or delete columns between them, and still get the growth you want.

• Marked as answer by JMK53 15 hours 43 minutes ago

Thank you very much