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


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 (“=”).

This example demonstrates how to create a simple formula using constants and calculation operators, and add this formula to a cell. Constants are values that are not calculated (e.g., date values, numbers, text strings). Operators specify what calculations should be performed on a formula’s elements.

// Use constants and calculation operators in a formula.
workbook.Worksheets[0].Cells["B2"].Formula = "= (1+5)*6";

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

See Also