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.