Microsoft Office Tutorials and References
In Depth Information
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
Place your cursor in the cell in
which you want to create your
Type the name of the constant
As you type, a list of possible
values appears. Double-click a
value to place it in the formula.
l The cell displays the result.