Most valuable professional
  • Hot Topics

Excel Excluding FALSE elements from arrays...

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:

  • Excel
  • Microsoft Excel