Microsoft Office Tutorials and References
In Depth Information
Figure 22-3: Formulas in the range C4:C7 use an absolute reference to cell C1.
Notice that the reference to cell C1 is an absolute reference. When the formula is copied to other cells in column
C, the formula continues to refer to cell C1. If the reference to cell C1 were a relative reference, the copied for-
mulas would return an incorrect result.
Operator precedence problems
Excel has some straightforward rules about the order in which mathematical operations are performed in a for-
mula. In Table 22-1, operations with a lower precedence number are performed before operations with a higher
precedence number. This table, for example, shows that multiplication has a higher precedence than addition.
Therefore, multiplication is performed first.
Table 22-1: Operator Precedence in Excel Formulas
* and /
Multiplication and division 4
+ and –
Addition and subtraction
=, <, >, and <> Comparison