press Ctrl+Shift+Enter to create an array formula. Excel will fill the selected range with the TREND results. Using the FORECAST Function for Different Scenarios Repeat the steps for the FORECAST ...

While the other formulas can do some magical things ... There are several different types of FORECAST functions available in Excel. You can use the FORECAST.ETS function to calculate a potential ...