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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
