ARRAYFORMULA

Google's Sample Usage prints ARRAYFORMULA(A1:C1+A2:C2) and NO result, and populates none of the cells, so both the data and the answer here are this corpus's. The result is DERIVED from the page's definition -- "Enables the display of values returned from an array formula into multiple rows and/or columns" -- with the `array_formula` argument described as "a mathematical expression using one cell range or multiple ranges of the same size". ARRAY RESULT: this case spills more than one cell, so it is written as a real array formula over an explicit check_range and compared cell by cell in row-major order, the same convention SORT, UNIQUE, SEQUENCE and TEXTSPLIT already use in this corpus. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

The page's own second sample formula, over data this corpus supplied. 6+7+8+9+10 = 40. This is the case that exercises the SECOND half of the definition, "the use of non-array functions with arrays" -- IF is scalar, and without the wrapper it would see the range as a single condition rather than ten. DERIVED, not published. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

DERIVED. The page describes ARRAYFORMULA as ENABLING array display, never as changing a value, so wrapping a scalar must be a no-op. Google publishes no example of this. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

DERIVED from the same "use of non-array functions with arrays" clause: LEN of a range yields 1, 2 and 3, which sum to 6. Summed rather than spilled so the assertion is a single unambiguous number. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

Google's Sample Usage prints ARRAYFORMULA(A1:C1+A2:C2) and NO result, and populates none of the cells, so both the data and the answer here are this corpus's. The result is DERIVED from the page's definition -- "Enables the display of values returned from an array formula into multiple rows and/or columns" -- with the `array_formula` argument described as "a mathematical expression using one cell range or multiple ranges of the same size". ARRAY RESULT: this case spills more than one cell, so it is written as a real array formula over an explicit check_range and compared cell by cell in row-major order, the same convention SORT, UNIQUE, SEQUENCE and TEXTSPLIT already use in this corpus. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

The page's own second sample formula, over data this corpus supplied. 6+7+8+9+10 = 40. This is the case that exercises the SECOND half of the definition, "the use of non-array functions with arrays" -- IF is scalar, and without the wrapper it would see the range as a single condition rather than ten. DERIVED, not published. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

DERIVED. The page describes ARRAYFORMULA as ENABLING array display, never as changing a value, so wrapping a scalar must be a no-op. Google publishes no example of this. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

DERIVED from the same "use of non-array functions with arrays" clause: LEN of a range yields 1, 2 and 3, which sum to 6. Summed rather than spilled so the assertion is a single unambiguous number. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

Google's Sample Usage prints ARRAYFORMULA(A1:C1+A2:C2) and NO result, and populates none of the cells, so both the data and the answer here are this corpus's. The result is DERIVED from the page's definition -- "Enables the display of values returned from an array formula into multiple rows and/or columns" -- with the `array_formula` argument described as "a mathematical expression using one cell range or multiple ranges of the same size". ARRAY RESULT: this case spills more than one cell, so it is written as a real array formula over an explicit check_range and compared cell by cell in row-major order, the same convention SORT, UNIQUE, SEQUENCE and TEXTSPLIT already use in this corpus. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

The page's own second sample formula, over data this corpus supplied. 6+7+8+9+10 = 40. This is the case that exercises the SECOND half of the definition, "the use of non-array functions with arrays" -- IF is scalar, and without the wrapper it would see the range as a single condition rather than ten. DERIVED, not published. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

DERIVED. The page describes ARRAYFORMULA as ENABLING array display, never as changing a value, so wrapping a scalar must be a no-op. Google publishes no example of this. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.

DERIVED from the same "use of non-array functions with arrays" clause: LEN of a range yields 1, 2 and 3, which sum to 6. Summed rather than spilled so the assertion is a single unambiguous number. Google's ARRAYFORMULA page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093275.