Formulas

To create a formula in a cell, use the CellRange.Formula property of the Cell object. Assign the required formula to this property as a string starting with the equals sign ("=").

The following examples demonstrate how to create and use different formulas in cells: