Excel Defined Names

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.