Microsoft Office Tutorials and References
In Depth Information
CHAPTER 8 Logical Functions
Logical Functions Overview
Logical functions test cells and ranges and return a logical result in the form of
text and numbers. A logical function operates under a logical test. For example,
if you want to apply a simple addition based on whether a cell has a number in it,
you could use an IF function to test the cell then apply the simple addition if the
logical result is true.
The following functions are discussed in this chapter.