Linear interpolation between two numbers in Excel to solve for y?

Hi all,

I have two known data points I need to interpolate between.

x₁ = 1, y₁= 0,85

x₂ = 5, y₂= 1,0

I want to solve this for x = 1,32 and find the corresponding y value.

Doing it by hand, I found that the gradient is change in Y/change in X = 0,15/4 = 0,0375

So, an increase of +0,32 from 1 to 1,32 along x, should give an increase of 0,32 * 0,0375 = 0,012 in Y direction.

So, y(1,32) = 0,85 + 0,012 = 0,862, which seems correct.

But, I'm thinking that it would be better to present this in Excel since it's part of a presentation. I was thinking there'd be a way to interpolate, but it seems harder than I imagined it to be.

Any advice?

Thanks in advance!

Elijah

For something like this, where there are only two data points, I tend to use the TREND() function: https://support.office.com/en-us/art...3-9a7cf7b51ef1

As simple as this should have been, I would be curious to see what you have tried that did not work. That would help us see what you are not understanding.

I would have expected you to:
1) Enter 1 into B2, 5 in B3, 0.85 in C2, 1 in C3.
2) Enter =TREND(C2:C3,B2:B3,1.32) into a cell.