Excel Top Tip #2

Constant values are often used in calculations. e.g.current VAT rate; Sterling/Euro exchange rate; Markup; Current tax rate band A etc. Name these constants rather than using the values so that if they change you only have to change the value in one place not in every calculation.

Insert and label constants

Add Constant values

Comments are closed.