O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

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

Start Free Trial

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.

Start Free Trial

No credit card required