Home Excel 2002 Worksheets Define A Constant For Equations
Search MS Office A-Z | Search Web Pages/ Design A-Z
Define A Constant For Equations
- Click on Insert | Name | Define.
- Select a name for the constatn such as GrowthRate.
- Enter the constant in the Refers To area, such as 0.17 (or 17%).
- Click OK.
- When you write a forumla such as =StartValue*GrowthRate, Escel will automatically use the constatant you've defined.
- To change the value of the named constant in every forumla, simply change the value.