Linear Interpolation in Excel | Fill in Missing Values

=IFERROR(FORECAST.LINEAR(A2,C2:D2,E2:F2),NA())

[rachelng]

I cant thank you enough for this tutorial. It is clear and well explained. I was able to understand the Linear Interpolation and how to apply using Excel application. Without the instruction, I almost calculate the missing value in a 500 rows dataset manually based on a equation.

[cfnrgor]

Hello Karina. This is a nice job. Thanks for sharing.

[shivalaveti]

quick question, can please explain why have you created two columns before and after ? it will be helpful to understand .

[APMSTEMCorps]

How do you think I could interpolate with an interval of my desire? Examples 5, 10, 15 and so on

[nutlugi]

if anyone can help, my forecast column is never showing more than one value consecutively, even where there are three values missing in a row. always just the last one that shows

[TUKARAMSHETYE-vtor]

How to do interpolation using Power query ?