Excel Tip of the Day
Simplify maintaining formulas with named constants
When you create a set of formulas that incorporate a value that doesn't change, you can make your formulas more readable by replacing the value with a named constant. Just as you can name worksheet ranges, you can assign a name to a specific value. To name a constant, display the Define Name dialog box by choosing Insert | Name | Define from the menu bar. After typing a name for the constant, replace the information in the Refers To text box with the constant value and click OK. You can now substitute the name you used in place of the value as you construct formulas.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.