increment of two data by steps

[ttik]

hi,

give these two data with prices
sqm price
1 20.55
10 57.43

then i expand the sqm row by .25 increment between the two numbers (1 and 10)
1.25
1.50
1.75
and so on to
9.75

what is the formula to get the prices for each increment?

Thanks

[JohnTopley]

There are instructions at the top of the page explaining how to attach your sample workbook.

And please update your profile with your Location and Excel version as replies can (do) depend on knowing this data.

[JohnTopley]

Increment with data in A1:B2

in C1

=($B$2-$B$1)/(($A$2-$A$1)*4)

with increments in column D (1.00. 1.25. 1.50.....10.00)

in E1

=$B$1+$C$1*(ROWS($1:1)-1)

[ttik]

Thanks John for taking the time to help me. I do appreciate it.

[JohnTopley]

You're welcome.

And please update your profile with your Location and Excel version as replies can (do) depend on knowing this data.