Get Business Solutions Tricks of the Microsoft Office 2007 Gurus now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.
IN THIS CHAPTER
Allowing Only Certain Values in a Cell
Looking Up a Value in a Discount Rate Schedule
Looking Up a Customer Account Number
Generating Account Numbers
Generating Random Numbers to Test Worksheet Models
Removing Excess Spaces from a Cell
Removing Unprintable Characters from a Cell
Extracting a Person’s First Name or Last Name
Building an Accounts Receivable Aging Worksheet
Converting Mainframe Dates to Excel Dates
Calculating Tiered Bonuses
Calculating the Number of Weekdays Between Two Dates
Determining the Fiscal Quarter in Which a Date Falls
Setting a Product Price Point
Calculating the Principal and Interest for a Loan
Determining How Much You Can Borrow
Calculating the Future Value of an Investment ...