Select a solution

  • How to avoid broken formulas

    Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.

  • Guidelines and examples of array formulas

    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.

  • Using formulas in Excel tables

    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.

  • Overview of formulas

    Learn how Excel formulas work. Troubleshoot common formula problems. Find links to specific help on functions.