How to implement interpolation in EXCEL

How to implement interpolation in EXCEL? How to implement the formula?

1. First, create a simple table to demonstrate what is to be done next.

Recommended tutorial: excel tutorial

2. Next, find the sum of parameter 1 and parameter 2. If there are many parameters, There are many columns that require summing, so it is very convenient to set the formula in the cell.

3. Click - fx. Add the required functions.

4. Select the corresponding function and click OK.

5. Set the cursor in Number1, then click the corresponding cell in the table, then set the cursor in Number2, and then click the corresponding cell in the table. grid, and the same applies to other Numbers. After selecting, click OK.

#6. At this time, the results in D2 will come out.

7. Then, place the cursor in the lower right corner of cell D2. When the cursor turns into a black ‘ ’, hold down the left mouse button and pull down.

#8. At this time, the addition formula in cell D2 will be filled downwards.

#9. The same applies to other cells. Don’t you think it’s very convenient?

The above is the detailed content of How to implement interpolation in EXCEL. For more information, please follow other related articles on the PHP Chinese website!