Define Constant Values
In both XP/2003 Excel, you can define a Constant Value that can be used over and over again in your formulas. Let's say that you wanted a Constant Tax Rate of 5%. Follow these steps for an example:
- Using the Name tool you can define a constant.
- Go to Insert, Name, Define
- Type a name such as TaxRate.
- In the Refers to area, type the constant value for 5% (0.05) without the parenthesis and click the OK button.
- Now you can write a formula such as =SalePrice*TaxRate. Just be sure that the name matches exactly on the constant. You can also use existing data in a cell such as =A2*TaxRate or an amount =250.15 *TaxRate. Either one will work.
Your worksheet will now print with the file path and name in your Header or Footer. This will change if the file's location changes as well.
Tip is by Helen Bradley, from PC Magazine 4 May 2004.
Just click on the button for the Tiproom's Home Page.
Date of last revision: 26 January 2006.