Lists possible ways to interpret and calculate a formula in a worksheet.
Formula is calculated as if it is entered in the worksheet cell in the usual way. It does not operate with arrays to return arrays.
Formula is calculated as an array formula in a worksheet.
The formula works with an array of values.