and
is used to change the order in which Excel performs calculations
operators are used to perform mathematical calculations.
Answers
Answered by
3
Parentheses are used to change the order in which Excel performs calculations operators are used to perform mathematical calculations.
To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first. For example, the following formula produces 11 because Excel calculates multiplication before addition. The formula multiplies 2 by 3 and then adds 5 to the result.
In contrast, if you use parentheses to change the syntax, Excel adds 5 and 2 together and then multiplies the result by 3 to produce 21.
Similar questions