i-nth logo

Excel array formulas, functions and constants - examples and guidelines

Excel array formulas, functions and constants - examples and guidelines
28 February 2015

In this tutorial, you will learn what an Excel array formula is, how to enter it correctly in your worksheets, and how to use array constants and array functions in Excel.

Topics covered:

  • What is an array formula in Excel?
  • How to enter an array formula (CTRL + SHIFT + ENTER).
  • How to evaluate portions of an array formula (F9 key).
  • Single-cell and multi-cell array formulas in Excel.
  • Excel array constants.
  • AND and OR operators in Excel array formulas.
  • Double unary operator in array formulas.

Full article: Excel array formulas, functions and constants - examples and guidelines

Essential reading

Latest articles

Consulting

We can help you make better spreadsheets:

  • Reviewing your spreadsheets for errors.
  • Advice about improving your spreadsheets.
  • Training in spreadsheet good practice.

Contact us