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:
- How to: Create Formulas Using Cell References
- How to: Create Formulas Using Cell Names
- How to: Create Named Formulas
- How to: Create Formulas Using Functions
- How to: Create Array Formulas
- How to: Create Shared Formulas
- How to: Create a Simple Custom Function
- How to: Create a Custom Function that Returns an Array