As you have already seen, Excel 2003 puts an impressive variety of formulas and functions at your disposal. There is still another powerful and flexible mathematical tool available that we have not yet explored, namely, array formulas.

In this lesson you will learn what array formulas are and how to use them. You will learn how to combine array formulas with Excel functions, with an emphasis on using array formulas with the IF function.

Note the braces { } denoting an array formula.