Psion Teklogix 32M/64M, netBook manual Use = to enter formulae

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 = to enter formulae

Sheet 48