Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Using Lookup, Logical, and Reference Functions
Using Lookup, Logical, and
In This Chapter
▶ Using IF to take a course of action
▶ Returning a value with CHOOSE
▶ Applying logic with AND, OR, and XOR
▶ Finding where values are
▶ Looking up values in a table
▶ 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 you’re looking for. Looking for something
in a large, complex worksheet can seem like the old needle-in-a-haystack
routine. It’s okay to admit it. After all, it happens to the best of us! I’m here to
help. In this chapter, I show you a slew of functions that make it easy to look
up information that’s spread around the rows and columns.