Mape Formula Excel / 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.