Excel: Named Constants
Learn how to create and use Excel Named Constants in formulas for faster, error-free calculations for Excel 2003, 2007, and 2010.
Using Name Manager (on Formulas Tab in Excel 2007/2010) or Name, Define on Insert menu (Excel 21003), add its name e.g. vat, and in the Refers To window, type “=0.14”. Now it can be used in a formula, e.g. “=B12*vat”.
To create a User Defined Function that uses it to add VAT, try:
Use in your workbook as follows “=VatInc(A1). The “vat” value includes the equal sign (“=0.14”). This function uses Right to strip that out, otherwise an error will result. Cdbl converts the string.
Bio: This article was written by Jasper Cook, Excel guru and trombonist of note. Call or email us if KRS can assist you with your Excel: enquiries@krs.co.dev
Looking for a software partner?
Tell us about your project and we’ll show you how our team can help.
Found this useful? Share it.
