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 ...
Get A Guide to Microsoft Excel 2007 for Scientists and Engineers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
