Formulas

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.

1. Parentheses evaluation of expressions

2. Range evaluation

3. Evaluation of spaces within the expression.

4. Evaluation of commas within the expression

5. Evaluation of variables with negation sign (-)

6. Conversion of percentages(%)

7. Evaluation of exponents (with ^ sign)

8. Multiplication and Division operators (hold equal precedence).

9. Addition and Subtraction operators (hold equal precedence).

10. Evaluation of text operators

11. Evaluation of comparison operators (=,<>,<=,>=)