Array formulae should work consistently
At present some functions can be used in array formulae and others cannot. And it seems rather hit and miss as to which can and which can. All inbuilt functions should deliver results across ranges which work with array functions

1 comment
-
Daniel Smith commented
Great idea. I am regularly frustrated that logical AND OR and NOT do not work in array formula , forcing unwieldy nested IFs. Also the complex operations such as improduct di not work which means that a simple set of complex operations has to be spread out over multiple cells instead of calculated in on array formula.