In This Topic

Formulas

In This Topic

GcExcel .NET provides you with the ability to create and use formulas to carry out complex calculations on numerical data residing in cells or a range of cells. You can also use some built-in functions and operators to generate formulas and calculate values in cells. Formulas are written as algebraic expressions, statements, or equations that start with an "=" (equal to) sign. The computation of a formula always begins from left and extends towards the right as per the operator precedence. In case you want to modify the order of computation, you can enclose some specific portions within the formula in parentheses.

Shared below is the descending order of operations for GcExcel .NET formulas with the first one holding the maximum precedence and last one holding the minimum precedence.

- Parentheses evaluation of expressions
- Range evaluation
- Evaluation of spaces within the expression.
- Evaluation of commas within the expression
- Evaluation of variables with negation sign (-)
- Conversion of percentages(%)
- Evaluation of exponents (with ^ sign)
- Multiplication and Division operators (hold equal precedence).
- Addition and Subtraction operators (hold equal precedence).
- Evaluation of text operators
- Evaluation of comparison operators (=,<>,<=,>=)

In GcExcel .NET, managing formulas involves the following tasks.

- Formula Functions
- Set Formula to Range
- Set Table Formula
- Set Array Formula
- Precedents and Dependents
- Iterative Calculation
- Cross Workbook Formula