### Excel Array Formulas Overview

In Excel, an array formula carries out calculations on one or more elements in an array.

Array formulas are surrounded by curly braces "**{ }** ". These are added to a formula by pressing the **CTRL**, **SHIFT**, and **ENTER** keys after typing the formula into a cell or cells.

### Types of Array Formulas

There are two types of array formulas - those that are located in a single cell of a worksheet (single cell array formula) and those located in multiple cells (multi cell array formula).

### How a Multi Cell Array Formula Works

In the image above, the multi cell array formula is located in cells F1:F3 and it carries out the same mathematical operation of multiplication on the data in the ranges of D1:D3 and E1:E3.Because it is an array formula, each instance or copy of the formula uses different data in its calculations and each instance produces different results.

For example:

- The instance of the array formula in cell F1 multiplies the data is cell D1 by the data in cell E1.
- The instance of the array formula in cell F2 multiplies the data is cell D2 by the data in cell E2.
- The instance of the array formula in cell F3 multiplies the data is cell D3 by the data in cell E3.

### Multi Cell Array Formula Tutorial

The following steps in this tutorial cover creating the multi cell array formula seen in the image above.

**Tutorial Topics**