Interpolate Excel Values with Linear or Growth Formulas
Question details
Calculate values between two known points using either a linear or an exponential growth trend.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A student needs to estimate values between 0.08 at Year 2 and 2.1 at Year 20 and compare the results with an assignment hint.
- Observed behavior
- The desired values should follow the trend specified or implied by the assignment.
Enter the years you want to calculate in a column, such as A3 downward. Check whether the assignment expects a constant increase or a constant growth rate; two points alone do not establish which model is correct.
Use FORECAST.LINEAR for a constant increase
Use linear interpolation when the value should increase by the same amount each year.
In Excel, enter a year between 2 and 20 in cell A3. Add other target years below it.
In B3, enter =FORECAST.LINEAR(A3,{0.08,2.1},{2,20}) and press Enter.
Drag the fill handle at the bottom-right corner of B3 down alongside the years in column A.

Use GROWTH for exponential interpolation
Use exponential interpolation when the value should change by a constant growth rate.
Calculate interpolated values in WPS Spreadsheets
Use arithmetic formulas in WPS Spreadsheets to compare linear and exponential estimates between the two known years.
- 1. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open your Excel file.
- 2. Enter target years: Enter the years to estimate in column A, starting with A3.
- 3. Add both formulas: In B3, enter =0.08+(2.1-0.08)*(A3-2)/(20-2). In C3, enter =0.08*(2.1/0.08)^((A3-2)/(20-2)).
- 4. Fill and compare: Select B3 and C3, then drag the fill handle down beside the remaining years. Compare the two columns with the expected values.

Frequently Asked Questions
How do I choose between linear and exponential interpolation?
Use a linear formula for a constant increase per year and GROWTH for a constant percentage growth rate. Check the assignment instructions or compare both sets of results with the hint; two points alone cannot identify the correct trend.
Can I use cell references instead of entering the known values in the formula?
Yes. If the known years are in E10 and W10 and their values are in E11 and W11, use =FORECAST.LINEAR(A3,E11:W11,E10:W10) only if those ranges contain the corresponding known data points without intervening values you do not intend to include.
Why does GROWTH return an error for my values?
Check the known y-values supplied to GROWTH: they must all be positive. Also make sure the known year and value arrays have matching sizes.
What happens if I enter a year outside 2 through 20?
The formulas estimate beyond the known points, which is extrapolation rather than interpolation. Such estimates may be unreliable, especially if the trend changes.




