Fill a Status column for every row: High if amount in C > 1000, else Low, automatically as rows are added

公式

=ARRAYFORMULA(IF(C2:C="", "", IF(C2:C>1000, "High", "Low")))

说明

ARRAYFORMULA lets one cell fill a whole column. The inner IF leaves new blank rows empty so you do not paint High/Low down to row 1000.

步骤

  1. Put the formula in the header row’s adjacent cell (D2).
  2. C2:C is an open-ended range.
  3. Blank amounts stay blank; others get High or Low.

变体

Running row number

Auto ID as names are entered in A.

=ARRAYFORMULA(IF(A2:A="", "", ROW(A2:A)-1))

Join two columns

Full name fill-down without copying.

=ARRAYFORMULA(IF(A2:A="", "", A2:A&" "&B2:B))

IFS inside ARRAYFORMULA

Same idea as nested IF, flatter branches.

=ARRAYFORMULA(IF(C2:C="", "", IFS(C2:C>5000, "Critical", C2:C>1000, "High", TRUE, "Low")))