Hi there, When applying a built-in Excel function (such as AVERAGE) to an array, all FALSE elements are automatically excluded. For example, the formula: 3 is treated as being equivalent to 3 and so both formulae produce the value 3, as expected. However, the following formula: 1.33333333333333 produces the value 1.33333, which (as far as I'm concerned) is unexpected. I would have expected the above formula to produce the value 2, since the FALSE element in the resulting internal array *should* be ignored, and the formula should be equivalent to 2
This question generated 14 answers. To proceed to the answers, click here.
This thread is current as of April 15, 2015.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel