In this article:

Google Sheets Forecast Function (How to Use it in 2024)

May 8, 2024

In this article, we will explore what the Google Sheets FORECAST function is. We also cover how to use the FORECAST function in Google Sheets. Simply follow the steps below. 

What is the Google Sheets FORECAST function?

The FORECAST function in Google Sheets is a powerful tool used for making predictions based on existing data, typically in linear regression analysis. This function is particularly useful for forecasting future values based on historical data trends.

Google Sheets FORECAST Function Syntax

The basic syntax of the FORECAST function is:

FORECAST(x, data_y, data_x)


x is the independent variable for which you want to forecast a value. This is the point on the X-axis you are forecasting a value for.

data_y is the range of the dependent data set (historically known values). These are the data points corresponding to the Y-axis.

data_x is the range of the independent data set. These are the data points corresponding to the X-axis and should correspond in size and order to data_y.

How to Use the FORECAST Function in Google Sheets

Follow the steps below to use the FORECAST function in Google Sheets to predict future data based on existing trends. In this example, we will use a simple dataset to demonstrate how you can forecast future sales or other metrics. 

1. Input Your Dataset into a New Google Sheets Spreadsheet

Start by opening a new spreadsheet in Google Sheets. Enter your data, with one column for the independent variable (such as dates) and another for the dependent variable (like sales figures).

google sheets forecast

2. Identify Your Independent and Dependent Columns

In the provided dataset, 'Date' is the independent variable (x values) and 'Sales' is the dependent variable (y values). In other cases, x can be any numerical independent variable.

forecast google sheets

3. Choose a Cell for the Forecast Result

Select an empty cell where you want the forecasted result to appear. This cell will display the predicted value.

forecast in google sheets

4. Apply the FORECAST Function

Type in “=FORECAST(DATE(2024,1,1), B1:B12, A1:A12)” to predict sales for January 2024 using the provided dataset.

google sheets forecast function

5. Execute the Function and View the Result

After entering the formula, press Enter. Google Sheets will calculate and display the forecasted value for the specified date.

6. Review and Interpret the Forecasted Sales

Examine the forecast result to understand the estimated sales for the future date based on historical trends.

We hope that you now have a better understanding of how to use the Google Sheets FORECAST function. If you enjoyed this article, you might also like our article on how to use Google Sheets for budgeting or our article on how to set up the Google Sheets custom function. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->