Excel array formulas, functions and constants - examples and guidelines

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.