FORECAST and FORECAST.LINEAR functions - Microsoft Support
FORECAST and FORECAST.LINEAR functions. This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions.
Generate formula columns and rows with Copilot in Excel
Formula generation in Microsoft 365 Copilot allows you to create new columns or rows in your table that perform calculations based on existing data. For example, you might use a formula column to calculate the total cost per product, or a calculated row to …
Multiply and divide numbers in Excel - Microsoft Support
You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT (A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4:J6).
Create or change a cell reference - Microsoft Support
Create a cell reference by using the Link Cells command. Change a cell reference to another cell reference. Change a cell reference to a named range. Switch between relative, absolute, and mixed references. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. Need more help?
SORT function - Microsoft Support
The SORT function sorts the contents of a range or array. In this example, we're sorting by Region, Sales Rep, and Product individually with =SORT (A2:A17), copied across cells F2, H2, and J2. Syntax. SORT returns a sorted array of the elements in an array.