Home

Edit a named constant

%3CLINGO-SUB%20id%3D%22lingo-sub-811994%22%20slang%3D%22en-US%22%3EEdit%20a%20named%20constant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811994%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20edit%20the%20%3CU%3Evalue%3C%2FU%3Eof%20a%20named%20constant%20in%20a%20formula%3F%20I'm%20using%20a%20workbook%20where%20a%20summary%20sheet%20is%20calculating%20the%20registration%20fees%20due%20for%20teams%20entered%20into%20a%20sporting%20carnival.%20The%20designer%20has%20used%20an%20IF%20function%20to%20calculate%20the%20fees%2C%20with%20a%20named%20constant%20(the%20individual%20rego%20fee).%20Problem%20is%20the%20fee%20has%20been%20increased%20this%20year%20and%20I%20need%20to%20update%20the%20sheet%20to%20calculate%20at%20the%20new%20rate.%3C%2FP%3E%3CP%3EOr%2C%20do%20I%20just%20delete%20the%20current%20name%20and%20set%20a%20new%20one%20at%20the%20new%20rate%3F%3C%2FP%3E%3CP%3EThank%20you%2C%20much%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-811994%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-812088%22%20slang%3D%22en-US%22%3ERe%3A%20Edit%20a%20named%20constant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-812088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394852%22%20target%3D%22_blank%22%3E%40allison_cg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20to%20Formulas%20%26gt%3B%26gt%3B%20Name%20Manager%20or%20press%20Ctrl%2BF3.%3C%2FP%3E%3CP%3EThen%20find%20the%20constant%20name%2C%20select%20it%20and%20change%20its%20value%20from%20the%20box%20below%2C%20and%20then%20hit%20Enter.%3C%2FP%3E%3CP%3EAfter%20you%20close%20the%20Name%20Manager%20the%20change%20will%20be%20applied%20to%20all%20formulas%20that%20use%20this%20constant.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127567i23E35520B968DCBF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Change%20constant%20value.png%22%20title%3D%22Change%20constant%20value.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
allison_cg
Occasional Visitor

Hi all,

 

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?

Thank you, much appreciated

1 Reply

@allison_cg

 

Hi,

 

Go to Formulas >> Name Manager or press Ctrl+F3.

Then find the constant name, select it and change its value from the box below, and then hit Enter.

After you close the Name Manager the change will be applied to all formulas that use this constant.

Change constant value.png

 

 

Related Conversations