Excel Solutions - Defined Names
You can give a cell (or range of cells) a name.
For example, the following formula refers to two cells. [E1] is the price and [E2] is the VAT amount.
However, to make the formula easier to understand, we can give names to cells [E1] and [E2].
Simply click on cell [E1] and in the Name box, type in a new name (in this example it is ‘Price’).
Repeat for cell [E2] with the name of ‘VAT’
You can now use these names in your formulas.