Forum Discussion
Possible BUG: IsEven() and IsOdd() give #VALUE error with dynamic array parameter
Why do IsEven() and IsOdd() give a #VALUE error when used with a dynamic array parameter? E.g.: A1: =Sequence(10) B1: =IsEven(A1#) C1: =IsEven(--A1#) D1: =IsNumber(A1#) In the example abo...
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