ExcelBanter - Interpolating between two points

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Interpolating between two points (https://www.excelbanter.com/excel-discussion-misc-queries/145056-interpolating-between-two-points.html)

Hutt

Interpolating between two points

I would like to interpolater between two points in a data range. Is there a
function in Excel to help me with this?

Example:

X Y
1800 2.75
1600 2.44

I want to find Y at 1700.

Toppers

Interpolating between two points

Look at FORECAST function.

"Hutt" wrote:

I would like to interpolater between two points in a data range. Is there a
function in Excel to help me with this?

Example:

X Y
1800 2.75
1600 2.44

I want to find Y at 1700.

Jon Peltier

Interpolating between two points

Or TREND.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Toppers" wrote in message
...
Look at FORECAST function.

"Hutt" wrote:

I would like to interpolater between two points in a data range. Is
there a
function in Excel to help me with this?

Example:

X Y
1800 2.75
1600 2.44

I want to find Y at 1700.

All times are GMT +1. The time now is 03:18 PM.