Is it possible to edit the value of a named constant in a formula? I'm using a workbook where a summary sheet is calculating the registration fees due for teams entered into a sporting carnival. The designer has used an IF function to calculate the fees, with a named constant (the individual rego fee). Problem is the fee has been increased this year and I need to update the sheet to calculate at the new rate.
Or, do I just delete the current name and set a new one at the new rate?