Interpolating between two points

[Guest]

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.

 

[Guest]

Look at FORECAST function.

 

[Jon Peltier]

Or TREND.

- Jon