ARRAYFORMULA Function

Applies a formula to an entire range from a single cell in Google Sheets. Eliminates the need to copy formulas down a column — one formula handles the whole range.

Google Sheets

Синтаксис

ARRAYFORMULA(array_formula)

Параметры

Параметр	Описание
array_formula	The formula to apply across the range. Use range references instead of single cells.

Примеры

Calculate total for every row at once

=ARRAYFORMULA(B2:B*C2:C)

Результат: Multiplies every row's B and C values, filling the entire column

Conditional labels for all rows

=ARRAYFORMULA(IF(B2:B>100, "High", "Low"))

Результат: Labels every row as High or Low based on column B

Add a prefix to every cell in a column

=ARRAYFORMULA("ID-" & A2:A)

Результат: Prepends 'ID-' to every value in column A

Советы и лучшие практики

•ARRAYFORMULA is Google Sheets only — Excel uses Ctrl+Shift+Enter or dynamic arrays.
•Use open-ended ranges (A2:A instead of A2:A100) to auto-include new rows.
•Wrap with IF to avoid applying to empty rows: =ARRAYFORMULA(IF(A2:A<>"", formula, "")).
•Only one ARRAYFORMULA is needed per column — don't copy it to other cells.

Связанные формулы

QUERY FILTER IF SUMIF

Нужна другая формула?

Опишите, что вам нужно, обычным языком — и наш ИИ создаст формулу за вас.

Попробовать Генератор формул