Automatically fills the whole column with formulas based on the column on the left column or the range defined by you.
The label or header of the column. It is added to the cell where the function is executed. For example:
The formula of the first cell to be filled automatically. For example:
The behavior of the function. Choose either:
0(default) to fill only empty cells.
1to overwrite and recompute only if formula is different.
2to overwrite and recompute all cells.
Which column or range determines the length of the Autofill.
The formula parameter should get the right formula for the first cell of the row or column you want to fill automatically.