Excel: Named Constants

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:

Named Constants Excel

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