Formulas > =TREND()

How To Use TREND() Function in Google Sheets


Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.

Common questions about the TREND formula include: What is the syntax for the TREND formula? How do I use the TREND formula? What types of values can I input for the TREND formula?

The TREND formula can be used appropriately to compute the linear trend line for a set of given values.

The TREND formula is commonly mistyped as ""TRENDLINE"" or ""TENDLINE"".

Some common ways the TREND formula is used inappropriately include: Misusing the formula for non-linear curves, not inputting the correct number of arguments, and not properly using the correlation coefficient.

Common pitfalls when using the TREND formula include: Errors with inputted data, incorrect number of arguments, and faulty trend lines due to non-linear data.

Common mistakes when using the TREND formula include: Using the wrong formula for the data set, using the wrong number of arguments, and typing errors.

Common misconceptions people might have with the TREND Formula include: That it can be used for non-linear trends, and that it can automatically generate curves from data without user input.

How To Actually Use TREND() in Sheets

TREND(known_data_y, [known_data_x], [new_data_x], [b])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the TREND() formula:

Using TREND and AUTOFILL in Google Sheets

This video supports the Twelve Days of Christmas project in Applied Math, focusing on the syntax for TREND formula in Google Sheets.

Generate a TREND() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.