ARRAYFORMULA Generator
ARRAYFORMULA applies a formula to an entire column or range at once, eliminating the need to copy formulas down. It's a Google Sheets powerhouse for automated spreadsheets.
Syntax
=ARRAYFORMULA(formula)Try it — generate a ARRAYFORMULA formula
Examples
Calculate tax for all rows
=ARRAYFORMULA(IF(B2:B<>"", B2:B*0.18, ""))Multiplies every non-empty cell in column B by 18% tax rate. The IF prevents errors on empty rows.
Full name column
=ARRAYFORMULA(IF(A2:A<>"", A2:A&" "&B2:B, ""))Concatenates first name (A) and last name (B) for all rows at once.
Tips
- ✓Always wrap in IF(range<>"", ..., "") to handle empty rows gracefully.
- ✓ARRAYFORMULA only needs to be in one cell — it fills down automatically.
- ✓Not all functions work inside ARRAYFORMULA. VLOOKUP does, but QUERY and IMPORTRANGE don't.
Related Formulas
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
QUERY
QUERY is Google Sheets' most powerful function. It lets you use SQL-like syntax ...
UNIQUE
UNIQUE returns a list of distinct values from a range, removing duplicates. It's...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free