Skip to main content
O'Reilly home
    • Sign In
    • Try Now
    • Teams
      • For business
      • For government
      • For higher ed
    • Individuals
    • Features
      • Certifications
      • Interactive learning
      • Live events
      • Answers
    • Blog
    • Content sponsorship

Business Solutions Tricks of the Microsoft Office 2007 Gurus by

Get full access to Business Solutions Tricks of the Microsoft Office 2007 Gurus and 60K+ other titles, with free 10-day trial of O'Reilly.

There's also live online events, interactive content, certification prep materials, and more.

Start your free trial

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 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 ...

Get Business Solutions Tricks of the Microsoft Office 2007 Gurus now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.

Start your free trial

About O’Reilly

  • Teach/write/train
  • Careers
  • Community partners
  • Affiliate program
  • Submit an RFP
  • Diversity
  • O’Reilly for marketers

Support

  • Contact us
  • Newsletters
  • Privacy policy
facebook-logo linkedin-logo youtube-logo

Download the O’Reilly App

Take O’Reilly with you and learn anywhere, anytime on your phone and tablet.

Apple app store Google play store

Watch on your big screen

View all O’Reilly videos, Superstream events, and Meet the Expert sessions on your home TV.

Roku Payers and TVs Amazon appstore

Do not sell my personal information

O'Reilly home

© 2022, O’Reilly Media, Inc. All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.

Terms of service • Privacy policy • Editorial independence

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Get it now
Cover of Software Architecture Patterns