## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

Chapter 5

# Decision Functions

## Publisher Summary

This chapter deals with making decisions or having cell display a value that is conditional upon what is in one or more other cells. It begins with the logical comparison operators and Boolean functions. The logical comparison operators are used to make tests. This chapter examines the IF function and shows how to use SUMIF, SUMIFS, and SUMPRODUCT. The table lookup functions LOOKUP, VLOOKUP, and HLOOKUP are also examined. It concludes with some notes on conditional formatting.

This chapter deals with making decisions or having a cell display a value that is conditional upon what is in one or more other cells. We begin with the logical comparison operators and Boolean functions. We examine the IF function ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required