I am trying to learn some techniques in excel and I have values like these:

86.49
86.5
86.51
86.52
-
-
-
-
-
-
86.65

The values are increasing. I want to use linear interpolation in order to predict values from 86.52 until 86.65. How can I achieve this?

CodePudding user response：

You can you FORECAST and FORECAST.LINEAR functions. See Microsoft article