– an expression used to perform calculations
– begin with an equal ( = ) sign
– Composed of operands and operators
– May contain constants, cell references, ranges, and grouping symbols
Operators Used in Formula
*Operators specify the kind of calculation that you want to perform on the elements of a formula. Excel performs calculations in a standard order, but you can also control the order of calculations.
Operator Precedence in Excel Formula
*If you combine several operators in a single formula, Excel performs the operations in the order shown in the following table. If a formula contains operators with the same precedence — for example, if a formula contains both a multiplication and division operator — Excel evaluates the operators from left to right.
Sources: moodle.pshs-brc.edu.ph
office.microsoft.com
spreadsheets.abou.com
Walang komento:
Mag-post ng isang Komento