Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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

8 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Malcolm G shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Daniel Smith commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base