Google Sheets multiple nested ArrayFormula

Question

Does multiple nested ArrayFormula's have any effect in any circumstances? For example arrayformula(...arrayformula(...arrayformula(...)))

player0 · Accepted Answer · 2019-11-13 21:40:18Z

0

no, it does not. in fact, it's pointless to nest arrayformulae. ArrayFormula should be always wrapping the most outer part of your functions and therefore included only once

answered Nov 13, 2019 at 21:40

player0

131k14 gold badges92 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CodeCamper Over a year ago

True, except for when you are working with functions that of themselves output an array such as mmult you might want the arrayformula inside a function. I was just wondering if there was some crazy edge case where nesting an arrayformula in another arrayformula actually might change the behavior.

Collectives™ on Stack Overflow

Google Sheets multiple nested ArrayFormula

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related