1 / 9

Mastering Excel Array Formulas with Matrices: A Quick Guide

This mini guide covers Excel's unique array formulas and how they differ from standard formulas. Unlike standard formulas that output to a single cell, array formulas output to a range of cells that must be pre-selected. Learn to multiply matrices seamlessly by following a straightforward three-step process: selecting the output range, typing the formula (like =MMULT(A2:C4,E2:G4)), and entering it with CTRL-ALT-ENTER. Discover how to delete array formulas and troubleshoot errors effectively.

mendel
Download Presentation

Mastering Excel Array Formulas with Matrices: A Quick Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mini Excel Guide : Matrices

  2. Array Formula • There are two type of formula in Excel, standard formula and Array Formula • Array formula are different in two ways • Firstly they do not output to a single cell, they output to a range of cells • This output range of cells must be selected before the formula is entered • After the formula has been typed in you must enter it by selecting CRTL-ALT-ENTER • Lets look at an example of this from lecture 1

  3. We want to multiply these two matrices

  4. Step 1: Select the output range We select an output range with 3 rows and 3 columns to store the 3by3 output matrix

  5. Step 2: Type in the formula We type in the formula while the range is still selected, in this case the formula is =MMULT(A2:C4,E2:G4) to multiply the two matrices held in A2:C4 and E2:G4

  6. Step 3: Press Ctrl-Alt-Enter By pressing CTRL-ALT-ENTER we enter the array formula

  7. Deleting an Array Formula Select the entire output range and press delete

  8. Deleting Error If you do not select the entire output range and try to delete you get an error

  9. If you get stuck…. • If you get stuck press Escape (Esc)

More Related