You can use array formulas with the control.

An array formula can perform multiple calculations on one or more items in an array. Array formulas can return multiple results or a single result.

To create an array formula, select the cells you wish to put the formula in, type the formula, and then use Ctrl + Shift + Enter. This puts braces around the formula and places an instance of the formula in each cell of the selected range. In code, use the SetArrayFormula method instead of the SetFormula method.

In order to remove or change an array formula, you must select the original formula range first.