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