Entering Formulas

• Adding Formulas
• Specifying Cell References
• Creating and Using Custom Functions
• Automatically Recalculating and Updating Formulas
• Using Circular References in Formulas

Overview

You can define formulas (mathematical expressions) for currency, number, and percent cells. The fpSpread control has over 100 built-in mathematical, logical, and statistical functions, as described in the Built-In Functions as well as the ability to handle custom functions and custom names.

The following sections describe adding formulas to the sheet, and ways you can customize how you and users create and use formulas, including setting the style for cell references and creating custom functions.

If a mistake is made in a formula, or something changes within the sheet that causes an error in the formula, the formula will be changed and the incorrect value or reference will be replaced by an error code. For a list of error codes, see Built-In Functions.