Assign name manager in Excel
For example, I want to define Target Sales as $12,000 for the year 2016 in an Excel workbook and use it for all calculations in Workbook.
To do it in Excel, here is the answer:
a) To assign a constant to a NAME, click on "Name Manager" under "Formulas". In the "New Name" dialog box that appears, enter the name that you would like to assign to constant ("TARGET" in this case).
In the "Refers To" field, enter "12000".
b) The NAME can then be used in formulas to refer to the constant value as shown below.