To use the FORECAST or TREND function in Excel you should follow these steps:
- Create the table where you want your results to appear.
- Enter data into the table.
- In the cell that contains the predicted value, enter the FORECAST or TREND Function.
- Click the cell with the FORECAST or TREND Function to activate it.
- In the dialog box, select the known x-range and y-range and the new x-value.
- Check that the new x-value in the Trend Function dialog box is correct.
- Click OK.