Forum Discussion
Possible BUG: IsEven() and IsOdd() give #VALUE error with dynamic array parameter
Also interestingly, IsEven({1, 2, 3, 4}) works, as does IsEven(Sequence(4)). IsEven(A1:A4) gives a #VALUE error, while IsEven(--A1:A4) works.
It seems like IsEven() and IsOdd() work with arrays, but not with references to arrays or ranges. As mentioned above, all of the other Is<X>() functions work with references to dynamic arrays or with ranges. This definitely seems like a bug, or at least a completely unnecessary functional inconsistency if this is somehow the desired behavior.
Thanks,
-Jeremy
Jeremy, not only. For example =EOMONTH(TODAY(),A1:A4) returns an error and =EOMONTH(TODAY(),+A1:A4) returns the spill. Some other functions also do not work with ranges and arrays in a same way.
We may consider that as a bug since we expect bit different functionality. Or we may consider that as a different behaviour, specific for different functions.
In any case I don't think old functions will be re-writing to make them work exactly the same way with dynamic arrays. It take years and introduces a lot of new bugs. Is not worth.