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.

Let us consider a hypothetical example to demonstrate the FORECAST.ETS function. The quarterly household expenditure from the March 2021 quarter to March 2024 quarter is given in the Excel screenshot.