Microsoft Office Tutorials and References

In Depth Information

CREATE FORMULAS

that include names

Constructing formulas can be complicated, especially

when you use several functions in the same formula

or when multiple arguments are required in a single

function. Using named constants and named ranges

can make creating formulas and using functions

easier by enabling you to use terms you have created

that clearly identify a value or range of values. An

argument is information you provide to the function

so the function can do its work. A named constant is

a name you create that refers to a single, frequently

used value; see Task #12. A named range is a name

you assign to a group of related cells; see Task #11.

To insert a name into a function or use it in a

formula or as a functionâ€™s argument, you must type

it, access it by using Use in Formula on the Formulas

tab, or select it from the Function Auto-complete list.

U
SE A
C
ONSTANT OR
R
ANGE
N
AME IN A

F
ORMULA

1

Place your cursor in the cell in

which you want to create your

formula.

2

Type the name of the constant

or range.

As you type, a list of possible

values appears. Double-click a

value to place it in the formula.

1

2

3

Press Enter.

l
The cell displays the result.

30