[Solved] Calculate incremental values between two numbers

[PeterA]

I have a column that about half way down has the value 12.99 in it (position 18 down) then a little further down I have 12.01 (position 24).

Is it possible to make it fill in the blank boxes between those two numbers.

Then additionally how do I then go upwards from that position no18 upward to box 1, also having it calculate incremental values. And again from position 24 down to where ever I want it to stop?

[robleyd]

Did you look at Data | Fill ? I think that’s the menu item as I don’t have access to AOO on this iPad.

[PeterA]

No I have not, I will take a look, and do some more googling.

The thing is that I don't really know what it is called that I want to do. So it's hard to search for it.

[MrProgrammer]

I have a column that about half way down has the value 12.99 in it (position 18 down) then a little further down I have 12.01 (position 24). Is it possible to make it fill in the blank boxes between those two numbers.

Put formula =FORECAST(ROW();{12.99|12.01};{18|24}) in your cells. If you then want numbers in the cells, instead of formulas, use Edit → Copy → Edit → Paste Special → Numbers or run Text to Columns (see Q25/A25).

The thing is that I don't really know what it is called that I want to do. So it's hard to search for it.

You want Linear Interpolation, which FORECAST can calculate.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know