If you are looking for using the **FORECAST function with multiple variables in Excel**, then you have come to the right place. Here, we will walk you through** 6 **easy examples to do the task smoothly.

**Table of Contents**hide

**Download Practice Workbook**

You can download the Excel file and practice while reading this article.

## 6 Examples of Using FORECAST Function with Multiple Variables in Excel

In the following dataset, you can see the **Year** and corresponding **Sales**. Here, we will have to determine the **Sales** for the year** 2022**. To do so, we will use **the FORECAST function**** with multiple variables**. Here, we used **Excel 365**. You can use any available Excel version.

### 1. Using FORECAST Function with Multiple Variables in Excel

In this method, we will use the** FORECAST function with multiple variables** to determine the **Sales** for the year **2022**.

**Steps:**

- First of all, we will type the following formula in cell
**C12**.

`=FORECAST(B12, C5:C11, B5:B11)`

**Formula Breakdown**

**FORECAST(B12, C5:C11, B5:B11)**â†’**the FORECAST function**determines the future value based on a current value.**B12**â†’ is the current value of the Year.**C5:C11**â†’ is the known range of Y values. In this case, these are the known**Sales**.**B5:B11**â†’ is the known X value. In this case, these are the known**Years**.**FORECAST(B12,C5:C11,B5:B11)**â†’ becomes**Output: $20971**

**Â**At this point, press**ENTER**.- Therefore, you can see the result in cell
**C12**.

**Read More: ****TREND vs FORECAST Function in Excel (3 Handy Examples)**

### 2. Applying FORECAST.LINEAR Function

In this method, we will use** the FORECAST.LINEAR function with multiple variables** to determine the** Sales** for the year **2022**.

**Steps:**

- First, we will type the following formula in cell
**C12**.

`=FORECAST.LINEAR(B12,C5:C11,B5:B11)`

**Formula Breakdown**

**LINEAR(B12,C5:C11,B5:B11)**â†’**the FORECAST.LINEAR function**determines the future value based on a current value.**B12**â†’ is the current value of the Year.**C5:C11**â†’ is the known range of Y values. In this case, these are the known**Sales**.**B5:B11**â†’ is the known X value. In this case, these are the known**Years**.**LINEAR(B12, C5:C11, B5:B11)**â†’ becomes**Output: $20971**

**Â**At this point, press**ENTER**.- Hence, you can see the result in cell
**C12**.

**Read More: ****How to Use VBA Forecast Function in Excel (3 Ideal Examples)**

### 3. Inserting FORECAST.ETS Function with Multiple Variables

In this method, we will use** FORECAST.ETS function with multiple variables** to determine **Sales **for the year **2022**.

**Steps:**

- First, we will type the following formula in cell
**C12**.

`=FORECAST.ETS(B12,C5:C11,B5:B11)`

**Formula Breakdown**

**ETS(B12,C5:C11,B5:B11)**â†’**the FORECAST.ETS function**determines the future value based on existing historical value.**B12**â†’ is the**target_date**.**C5:C11**â†’ are the historical values.**B5:B11**â†’ is the**timeline**or known years.**ETS(B12, C5:C11, B5:B11)**â†’ becomes**Output: $ 21030**

- At this point, press
**ENTER**. - Hence, you can see the result in cell
**C12**.

**Read More: ****[Fixed!] FORECAST Function Not Accurate in Excel (5 Solutions)**

### 4. Use of FORECAST.ETS.CONFINT Function

In the following dataset, you can see the **Year** and **Sales** values. However, the **Sales **for the year **2019** are missing. We will use **FORECAST.ETS** function to determine **FORECAST.ETS** for the year **2019**. Then, we will use **the FORECAST.ETS.CONFINT function** to determine **Confidence Interval**. After that, we will determine **Lower Bound **and **Upper Bound**.

**Steps:**

- In the beginning, find out the
**FORECAST.ETS**value, we will type the following formula in cell**D9**.

`=FORECAST.ETS(B9, C5:C8, B5:B8)`

- At the moment, press
**ENTER**. - As a result, you can see the result in cell
**D9**.

- Furthermore, to find out the
**Confidence Interval**, we will type the following formula in cell**E9**.

`=FORECAST.ETS.CONFINT(B9,C5:C8,B5:B8)`

**Formula Breakdown**

**ETS.CONFINT(B9, C5:C8, B5:B8) â†’**determines the Confidence Interval for a forecast value at a specified target date.**B9****â†’**is the**target_date**.**C5:C8 â†’**are the historical values.**B5:B8 â†’**is the timeline.**ETS.CONFINT(B9, C5:C8, B5:B8)****â†’**becomes**Output: 288.5851827**

- Then, press
**ENTER**. - As a result, you can see the
**Confidence Interval**for the Year**2022**in cell**E9**.

- Moreover, to find out the
**Lower Bound**, we will type the following formula in cell**F9**.

`=D9-E9`

- This simply subtracts the
**Confidence Interval**from**FORECAST.ETS**value.

- At this point, press
**ENTER.** - As a result, you can see the Lower Bound in cell
**F9**.

- Moreover, to find out the
**Upper Bound**, we will type the following formula in cell**G9**.

`=D9+E9`

- This simply adds the
**Confidence Interval**from**FORECAST.ETS**value.

- Afterward, press
**ENTER**. - Therefore, you can see the
**Upper Bound**in cell**G9**.

### 5. Employing FORECAST.ETS.SEASONALITY Function

In this method, we will use **FORECAST.ETS.SEASONALITY function with multiple variables **to determine the **Season Length**.

**Steps:**

- In the beginning, we will type the following formula in cell
**C17**.

`=FORECAST.ETS.SEASONALITY(C5:C16,B5:B16,1,1)`

**Formula Breakdown**

**ETS.SEASONALITY(C5:C16, B5:B16,1,1)**â†’ determines the Season Length foe specific repetitive time length.**C5:C16**â†’ are the historical values.**B5:B16**â†’ is the**timeline**.**1**â†’ is the**Data Completion****1**â†’ is the**Aggregation****ETS.SEASONALITY(C5:C16, B5:B16,1,1)**â†’ becomes**Output: 4**

**Â**After that, press**ENTER**.- Hence, you can see the result in cell
**C17**.

### 6. Using FORECAST.ETS.STAT Function with Multiple Variables

In this method, we will use **FORECAST.ETS.STAT** **function for multiple variables** to determine the statistical type values.

We have **8** statistical argument types. These are:

**Alpha (base value)**â€“ is a smoothing value between 0 and 1, which controls how the data points are weighted. A higher value indicates that recent data is weighted more heavily.**The beta (trend value)**â€“ values between 0 and 1 determine the trend calculation**.**Recent trends are given more weight when the value is higher.**Gamma (seasonality value)**â€“ A value between 0 and 1 that controls ETS forecast seasonality. An increasing value indicates that the recent seasonal period should be given more weight.**MASE (mean absolute scaled error)**â€“ a way to evaluate how accurate a forecast was.**SMAPE (symmetric mean absolute percentage error)**â€“ an evaluation of accuracy based on the proportion or magnitude of errors.**MAE (mean absolute error)**â€“ independent of their direction, calculates the average size of the forecast errors.**RMSE (root mean square error)**â€“ an evaluation of the discrepancies between the observed and projected values.**Step size detected**â€“ the timelineâ€™s detected step size.

Next, we will determine the **Value** of these argument types.

**Steps:**

- First of all, to find out the value of Alpha, we will type the following formula in cell
**E5**.

`=FORECAST.ETS.STAT(C5:C12,B5:B12,1)`

**Formula Breakdown**

**ETS.STAT(C5:C12,B5:B12,1)**â†’**the FORECAT.ETS.STAT function**returns the statistical value.**C5:C12**â†’ are the historical values.**B5:B12**â†’ indicate the timeline.**1**â†’ indicates the**Statistics_type**which is**Alpha**in that case.**ETS.STAT(C5:C12, B5:B12,1)**â†’ becomes**Output: 0.126**

**Â**Then, press**ENTER**.- As a result, you can see the output in cell
**E5**.

- Furthermore, to find out the
**Beta**value, we type the following formula in cell**E6**.

`=FORECAST.ETS.STAT(C5:C12, B5:B12,2)`

**Â**Then, press**ENTER**.- Therefore, you can see the result in cell
**E6**.

- In addition, to find out the
**Gamma**value, we type the following formula in cell**E7**.

`=FORECAST.ETS.STAT(C5:C12, B5:B12,3)`

- Then, press
**ENTER**. - Therefore, you can see the result in cell
**E7**.

- Along with that, to find out the
**MASE**value, we type the following formula in cell**E8**.

`=FORECAST.ETS.STAT(C5:C12, B5:B12,4)`

- Then, press
**ENTER**. - As a result, you can see the result in cell
**E8**.

- Moreover, to find out the
**SMAPE**value, we type the following formula in cell**E9**.

`=FORECAST.ETS.STAT(C5:C12, B5:B12,5)`

- Then, press
**ENTER**. - As a result, you can see the result in cell
**E9**.

- Afterward, to find out the
**MAE**value, we type the following formula in cell**E10**.

`=FORECAST.ETS.STAT(C5:C12, B5:B12,6)`

`Â `

- After that, press
**ENTER**. - As a result, you can see the result in cell
**E10**.

- After that, to find out the
**RMSE**value, we type the following formula in cell**E11**.

`=FORECAST.ETS.STAT(C5:C12, B5:B12,7)`

- Then, press
**ENTER**. - Therefore, you can see the result in cell
**E11**.

- Finally, to find out the
**Step Size**value, we type the following formula in cell**E12**.

`=FORECAST.ETS.STAT(C5:C12, B5:B12,8)`

- Furthermore, press
**ENTER**. - Therefore, you can see the result in cell
**E12**. - Also, you can see the complete
**Value**column.

## Practice Section

You can download the above Excel file and practice the explained methods.

**Conclusion**

Here, we show you** 6 **examples of using **the FORECAST function with multiple variables in Excel**. Thank you for reading this article. We hope it was helpful. If you have any queries, please let us know in the comment section. You can visit our website** Exceldemy** for more related articles.