assign name manager in Excel
Q2. Can I assign a NAME to a constant (similar to declaring constants in coding environment like VBA)?
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.