5. Formula and Function Tricks
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 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 the Number of Weekdays Between Two Dates
Determining the Fiscal Quarter in Which a Date Falls
Calculating the Principal and Interest for a Loan
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.