Chapter 9Using Powerful Functions: Logical, Lookup, and Database Functions
This chapter covers four groups of workhorse functions. If you process spreadsheets of medium complexity, you turn to logical and lookup functions regularly.
The logical functions, including the ubiquitous
IFfunction, help make decisions.
The information functions might be less important than they once were because Microsoft has added the
TYPEstill come in handy. The lookup functions include the powerful
INDIRECTfunctions. These functions are ...