Skip to Main Content
Excel Formulas and Functions For Dummies, 3rd Edition
book

Excel Formulas and Functions For Dummies, 3rd Edition

by Ken Bluttman
February 2013
Beginner content levelBeginner
408 pages
9h 10m
English
For Dummies
Content preview from Excel Formulas and Functions For Dummies, 3rd Edition

Chapter 14

Using Lookup, Logical, and Reference Functions

In This Chapter

arrow Using IF to take a course of action

arrow Returning a value with CHOOSE

arrow Applying logic with AND, OR, and XOR

arrow Finding where values are

arrow Looking up values in a table

arrow Matching data

Decision, decisions! If one of your students gets an 88 on the test, is that a B+ or is it an A? If your company’s new product earns at least $15,000,000 in revenue, how much of a bonus should you give to the team? Or do you have to get to $20,000,000 before you do that? How does this affect the financial statements?

Excel cannot make decisions for you, but it can help you make better decisions. Using functions, such as IF and CHOOSE, you can set up your worksheet to chart a course through the possibilities. Hey, things could be worse! Were it not for Excel, you might have to try the old Ouija board technique.

Excel also can help you find what ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Formulas & Functions For Dummies, 5th Edition

Excel Formulas & Functions For Dummies, 5th Edition

Ken Bluttman

Publisher Resources

ISBN: 9781118460856Purchase book