Use Named Constants to Store Numbers

-
Problem: It is also possible to assign a name to a constant. This could be useful if you have a number, such as a local sales tax rate, that changes once a year.
Strategy: From the menu, use Insert – Name – Define. Type a name like SalesTax. In the Refers to box, type =0.065 and click Add, as shown below



In this workbook, you can now use a formula such as =SalesTax*D2, as shown in below.



If the tax rate changes later use Insert – Name – Define to change the constant assigned to the name.

Summary: To name a constant in a workbook use Insert – Name – Define, type in the name of the constant, and then define the constant in the Refers to: box.

Comments

Post a Comment

Popular posts from this blog

Modify the scope of your Calendar work week

-
By default, the Work Week calendar view displays the five days of the traditional business week, Monday through Friday. To include Saturday and Sunday in that view, choose Options from the Tools menu. In the resulting Options dialog box, click Calendar Options in the Calendar section. In the Calendar Options dialog box, check Sat and Sun in the Calendar Work Week section. Then, click OK twice to return to the Calendar. You don't have to view a seven- or traditional five-day work week. Check the days of the week that apply to you for a custom work week view. For example, if you work Wednesday through Sunday, you can make those selections to build a view that reflects your schedule.
Read more

Use Find and Replace to apply formatting

-
You probably use Find and Replace to replace existing text with new text — that’s the feature’s typical use. However, it’s flexible enough to handle much more than switching out text. You can use it to apply formatting. For instance, let’s suppose you want to display your company name in blue so it stands out against the normal black text. You could review the document to find each occurrence of your company’s name and apply the appropriate color manually. But that would be tedious, and you’d risk missing an occurrence or two. Instead, use Find and Replace as follows: 1.From the Edit menu, choose Replace (or press [Ctrl]+H). 2.In the Find What control, type the text you want to format. In this case, that’s your company’s name. 3.Place the cursor in the Replace with 4.Click the More button/ Option. 5.Click the Format button and select Font. 6.Choose a color from the Font Color control’s palette and then click OK. (You can apply any combination of formats.) 7.Click Find Next to format ea...
Read more