Range Names - Formulas and Constants

You can create names that represent constants or formulas.

Create a name

Here I'm going to create a constant for the UK's VAT rate.

1. From the menu: Insert > Name > Define

2. In the "Names in workbook" box type "VAT"

3. In the "Refers to" box type "=17.5%"

4. Click on "OK"

Your constant for VAT is now ready to use.

In the next example I am going to create a name that will give me the date thirty days ago (TDA).

1. From the menu: Insert > Name > Define

2. In the "Names in workbook" box type "TDA"

3. In the "Refers to" box type "=NOW()-30"

4. Click on "OK"

In any cell type "=TDA" and you get the date from thirty days ago (based on your system's clock, of course).

See also ..

Dynamic Names