In This Topic

Formulas

In This Topic

DsExcel Java allows users to create and use formulas in order to facilitate financial analysis and improve data processing while saving both time and efforts.

Basically, a formula refers to an expression that helps in calculating the value of a cell quickly and accurately when applied in a worskheet. While applying formulas, you can also use some built-in functions and operators to generate formulas and calculate values in the cells.

In order to carry out complex arithmetic calculations, DsExcel provides support for adding and using formulas in a workbook. Formula computation always begins from left and extends towards the right based on 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 formulas in DsExcel Java. The first one holds the maximum precedence and last one holds 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 DsExcel Java, you can manage formulas in the following ways:

- Formula Functions
- Set Formula to Range
- Set Table Formula
- Set Array Formula
- Precedents and Dependents