Filter
Top Products
48Sheet
There are two types of cell reference you can use in a formula:
• Relative references, such as A2. These get updated when
copied and moved elsewhere. For example, a reference to
cell A2 in a formula in cell B3 will change to B2 if the
formula is copied to cell C3.
• Absolute references, such as $A$2. These contain a $ sign in
front of the parts of the reference that you don’t want to
change even if the formula is moved elsewhere. So, $A$2 in
cell B3 remains $A$2 when copied to cell C3.
• You can combine the two types of reference: A$5 in A6 will
become B$5 when copied to B8.
A formula which contains a reference to its own cell, either
directly or indirectly, is called a “circular reference”. You can find
any circular references in the worksheet using the Find
commands on the Edit menu. You should avoid making circular
references as they produce unpredictable results.
Use=toUse=to
Use=toUse=to
Use=to
enter formulaeenter formulae
enter formulaeenter formulae
enter formulae