Closed zhm closed 8 years ago
The AVERAGE should accept a single array parameter in addition to variadic arguments.
AVERAGE
The following should return the identical value:
AVERAGE(1, 2, 3); AVERAGE([1, 2, 3]);
Currently the 2nd form doesn't work, which makes AVERAGE(REPEATABLEVALUES(...)) confusingly return NaN.
AVERAGE(REPEATABLEVALUES(...))
NaN
This was fixed in 4feb0c12b95c2578efcac52be6cec1460f1e7a1d and that patch also includes several other usability improvements to commonly used functions.
The
AVERAGE
should accept a single array parameter in addition to variadic arguments.The following should return the identical value:
Currently the 2nd form doesn't work, which makes
AVERAGE(REPEATABLEVALUES(...))
confusingly returnNaN
.