Use the FORECAST Function: Apply FORECAST to predict a future value based on existing values and the linear trend. Specify the X Value: Enter the x-value for which you want to forecast the y-value.