Description Computes the average of a list of numbers in a Lotus-compatible fashion. This function is equivalent to the AVERAGE function, but its implementation treats text and logical values in cell and range references differently.
Syntax AVERAGEA(number_list)
Argument | Description |
---|---|
number_list | A list of up to 30 arguments separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text in cells referenced by this function is treated as the number 0 (this includes zero-length text). Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Text and logical values in arrays are ignored. Logical values referenced in cells or entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE. |
Examples This function returns 1.5: