Contact KRS: +27 (0) 21 681 2900 | enquiries@krs.co.za | Contact Us

Musings

Excel: Named Constants

9 Dec 2010 by Jasper Cook

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

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

Load more comments
Thank you for the comment! Your comment must be approved first
comment-avatar