Question: how to create a formula in excel using defined names?
Answer: Select a cell and enter a formula.
Place the cursor where you want to use the name in that formula.
Type the first letter of the name, and select the name from the list that appears. Or, select Formulas > Use in Formula and select the name you want to use.
Press Enter.