Create a name to represent a formula or a constant
- On the Insert menu, point to Name, and then click Define.
- In the Names in workbook box, enter the name for the formula.
- In the Refers to box, type = (equal sign), followed by the formula or the constant value.