Logical functions test cells and ranges and return a logical result in the form of text (True or False) or numbers (1 or 0). 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 and then apply the simple addition if the logical result is true. This chapter covers the functions in Table 12.1 that appear in bold.
Table 12.1. Logical Functions
Returns TRUE if all of the arguments are true in the formula, and FALSE if one or more are false.