You can use a name to refer to a piece of data or a cell reference. You can use the name in a formula so that the formula is easier to understand.
You can define a name in one of two ways:
Use the Names dialogue box on the function selector menu.
Use the SET_NAME
function, e.g.:
SET_NAME("VAT", 0.175)
creates a name VAT
and sets its value to 0.175.
In your formulae you can now use your name. For example:
A1*VAT
multiplies the contents of A1 by the value of VAT. This is useful because if you need to change the value of VAT any formulae including the name VAT will automatically be updated to use the new value.
Names must conform to the following rules: