Sign up for free
Functions

ARRAY_CONSTRAIN

Returns a result array constrained to a specific width and height.

Parameter List

Syntax
ARRAY_CONSTRAIN(array, num_rows, num_cols)
array

The range to constrain.

num_rows

The number of rows the result should contain.

num_cols

The number of cols the result should contain.

Examples

ARRAY_CONSTRAIN(A1:C1, 4) returns "Fill..." and cells A2..A5 are empty, B2..B5 have =1+1, C2..C5 all have similar formulas to C1.