Hi,

You are creating a name to represent a formula or a constant.

To create a named definition

1. On the Insert menu, point to Name, and then click Define.
2. In the Names in workbook box, enter the name for the formula.
3. In the Refers to box, type = (equal sign), followed by the formula or the
constant (constant: A value that is not calculated and, therefore, does not
change. For example, the number 210, and the text "Quarterly Earnings" are
constants. An expression, or a value resulting from an expression, is not a
constant.) value.

Challa Prabhu


"mp@ea" wrote:

What's the purpose of defining a name in a cell? How is it used?