autofill in equal increments between two numbers

Question

Level 1

8 points

autofill in equal increments between two numbers

Assume Cell A1 contains 85 and Cell A31 contains 69. Cells A2 to A30 are empty. How to autofill the series from 85 to 69 with equal increments.

MacBook Pro 14″, macOS 26.0

Posted on Oct 30, 2025 11:16 PM

Reply

Answer 1

Top-ranking reply

Yellowbox

Level 7

21,885 points

Oct 31, 2025 12:11 AM in response to Nut_Cracker

Hi Nut_Cracker,

Is this what you want?

Formula in A2 is A1−((85−69)÷30)

Fill down to Row 30

Or fill down to row 31 to check that the formula gives 69.000000000001

Close enough?

Regards,

Ian.

Reply

Answer 2

Camelot

Level 9

58,101 points

Oct 31, 2025 10:14 AM in response to Nut_Cracker

Or, use the built-in SEQUENCE() function. Set A2 to:

=SEQUENCE(29,1,$A$1,−(A1−A31)÷29)

Which reads as:

Create a sequence of 29 rows (the number of rows between row A1 and row 31), one column wide, starting with the value in $A$1, incrementing (or in this case decrementing) by the (difference between the values in cells A1 and A31) divided by the number of rows.

Reply