You can download this TREND Function Excel Template here – TREND Function Excel Template Example #1 Let us understand the working of TREND in Excel by Some Examples. TREND Function in Excel is very simple and easy to use. Go to formulas–>Choose More Function–>Statistical–>TREND In the advanced version, we will have a shortcut in the formula bar called more function and follow the below procedure. Select the category statistically once you choose the category, you will get a list of the function displayed as shown in the below screenshot.Choose the insert function, and you will get the below dialogue box, as shown below.We can find the TREND Function under Statistical function here we are going to see step by step procedure on how to use it : New_X-: This new x value is used to return corresponding y values.Ĭonst-: This const is a logical value, i.e. Known_ X-: This Known x_values is an independent array or range of data. Known_ Y-: This Known y_values is a dependent array or range of data. Note: The existing data needs to be linear data otherwise the output will be inaccurate.
