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.
- 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.
ORoperators in Excel array formulas.
- Double unary operator in array formulas.