Question

How do you use a range name in a formula

Answer 1

Answer:

Use names in formulas

1. Select a cell and enter a formula.
2. Place the cursor where you want to use the name in that formula.
3. Type the first letter of name, and select the name from the list that appears. Or, select the Formulas > use in Formula and select the name you want to use.
4. Press Enter.