Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas.
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with names for the items in a table.
Learn how Excel formulas work. Troubleshoot common formula problems. Find links to specific help on functions.