# How to Naming Formula in Excel

## The Formula in Excel

In this Excel tutorial I will show **how we can use the standard formula for the calculation** that you designate in the Name Manager and later a call in our calculations to the possible length of the final formula.

Notice in the picture below the standard VLOOKUP formula. This formula returns the data as a result of the condition of the cells 'D2'.

=VLOOKUP($D$2;$A$2:$B$7;2;FALSE)

In this case, this formula is not long, but if we imagine a formula that has a lot of arguments, then the formula can be very long.

This calculation can be presented in a different way. Just this formula called a certain name in **Excel Name Manager** and then type the name into a cell formula from the **Name Manager**.

## How to appoint a formula in Excel - Definition of Named Formula in Name Manager

- Appointment of a formula in Excel is very simple.
- Click the Formulas tab and then on the command Name Manager.
- It opens a dialogue box Name Manager.
- Click the New Name.
- In the Name field, type the name that you set for the respective formula
- In the Scope field, select the area that refers to a formula. Sheet or Workbook.
- If you want, you can enter a comment on what the formula refers and that results should be returned
- In the Refers to set your formula

These steps follow the above in the image below.

The situation **named formula in Excel Name Manager** looks like as shown below.

## The Calculation in Excel using Named Formula

And finally in a cell instead of formula you type the name of the formula that you **define in the Name Manager**.

An example of using named formulas, see the link, How to shorten a formula using the name formula.