A newer version of this page is available. Switch to the current version.

Formulas

To create a formula in a cell, use the Range.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: