Skip to content
Google Sheets functionNot in Excel

ARRAYFORMULA function in Excel

Excel doesn't have ARRAYFORMULA — here's what does.

Modern Excel evaluates array math natively and spills the result — the wrapper simply disappears.

What ARRAYFORMULA does in Google Sheets

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

=ARRAYFORMULA(array_formula)

Convert ARRAYFORMULA formulas to Excel

Before and after, formula by formula.

  1. Multiply two columns for every row:

    Google Sheets
    =ARRAYFORMULA(B2:B100 * C2:C100)
    Excel
    =B2:B100 * C2:C100

  2. IF over a whole column:

    Google Sheets
    =ARRAYFORMULA(IF(C2:C100 > 1000, "Big", "Small"))
    Excel
    =IF(C2:C100 > 1000, "Big", "Small")

    Any function that accepts a range spills automatically in dynamic-array Excel.

Worth knowing

  • Excel 2019 and older don't spill — legacy array formulas need Ctrl+Shift+Enter entry.

Converting more than one formula? The Excel ↔ Sheets translator rewrites whole workbooks and flags every ARRAYFORMULA so none slip through silently.

Browse Google Sheets google functions

More conversions to Excel