Home / Formula Types / Array / Trend

Formula generator for TREND function

The TREND function is used to calculate and predict values based on a linear trend using the least squares method. It takes known y-values, optional known x-values, optional new x-values, and an optional constant 'b' as input. The function returns an array of predicted y-values corresponding to the new x-values.

Formula generator

Spreadsheet AI is the #1 AI for generating and comprehending Excel and Google Sheets formulas. With its advanced capabilities, it goes beyond the basics by providing support for VBA and custom tasks. Streamline your spreadsheet with Spreadshee AI

Product Demo

How to generate an TREND formula using AI.

To obtain information on the ARRAY_CONSTRAIN formula, you could ask the AI chatbot the following question: “To get the TREND formula for your data, you can ask the AI chatbot the following question: "Is there a formula in Excel that can be used to predict a future value based on existing data points?"

TREND formula syntax

The TREND function in Excel is used to predict a linear trend in a set of data points. The syntax for the TREND function is: TREND(known_y's, known_x's, new_x's, [const]) - known_y's: This is the array or range of dependent (y) values in the data set. - known_x's: This is the array or range of independent (x) values in the data set. - new_x's: This is the array or range of new x values for which you want to predict the corresponding y values. - const (optional): This is a logical value that determines whether to force the intercept to be zero. By default, it is set to TRUE. The TREND function returns an array of predicted y values based on the linear trend calculated from the known x and y values. The number of predicted values will be the same as the number of new x values provided. Note that the known x and y values must have the same length, and the new x values must be in ascending order.

Use Cases & Examples

In these use cases, we use the TREND formula to predict future values based on existing data points. The TREND formula is commonly used in forecasting and trend analysis to estimate the values of a dependent variable based on the values of independent variables.

Sales Projection


Predict future sales based on historical sales data using the TREND function.


TREND(A2:A10, B2:B10, C2:C5)

Stock Price Analysis


Estimate future stock prices based on historical stock prices using the TREND function.


TREND(A2:A100, B2:B100, C2:C10)

Population Growth Projection


Forecast future population growth based on historical population data using the TREND function.


TREND(A2:A20, B2:B20, C2:C8)

AI tips

Enhance Your Excel Efficiency with AI Tips: Discover our innovative Excel add-in feature, ‘AI Tips.’ Streamline your workflow and boost productivity as AI-powered suggestions offer real-time insights for optimal spreadsheet organization, data analysis, and visualization. Elevate your Excel experience with intelligent recommendations tailored to your unique needs, helping you work smarter and achieve more.

Provide Clear Context

When describing your requirements to the AI, provide clear and concise context about the data you have, the specific task you want to accomplish, and any relevant constraints or conditions. This helps the AI understand the problem accurately.

Include Key Details

Include important details such as column names, data ranges, and specific criteria that need to be considered in the formula. The more precise and specific you are, the better the AI can generate an appropriate formula.

Use Examples

If possible, provide examples or sample data to illustrate the desired outcome. This can help the AI better understand the pattern or logic you are looking for in the formula.

Mention Desired Functionality

Clearly articulate the functionality you want the formula to achieve. Specify if you are looking for lookups, calculations, aggregations, or any other specific operations.


Frequently Asked Questions

  • The TREND function is used to calculate and predict a linear trend line for a set of data points in Excel. It can be used to forecast future values based on historical data.
  • To use the TREND function, you need to provide a known set of y-values and x-values. The function will then calculate the linear trend line equation and return the predicted y-values for the specified x-values.
  • The TREND function requires three arguments: known_y's, known_x's, and new_x's. The known_y's are the y-values of the known data points, known_x's are the x-values of the known data points, and new_x's are the x-values for which you want to predict the y-values.
  • No, the TREND function cannot handle missing or empty cells in the data. You need to make sure that the known_y's and known_x's have the same number of data points and that there are no missing or empty cells in either range.
  • Yes, the TREND function assumes a linear relationship between the x-values and y-values. If the relationship is not linear, the predictions may not be accurate. Additionally, the function may not work well with small data sets or data sets with outliers.