You can perform calculations in cells. You can use a built-in formula, a custom name, or a custom formula function. Users can also enter formulas in cells.
See the following topics for more information:
For a list of built-in formulas, refer to the Formula Reference. Refer to Sheet References in a Formula for information about using sheet references. The Cell References in a Formula topic provides information about the reference style. The ReferenceStyle property can be used to specify the type of cell reference.