DsExcel .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 DsExcel .NET formulas with the first one holding the maximum precedence and last one holding the minimum precedence.
In DsExcel .NET, managing formulas involves the following tasks.