Part II: Working with Formulas and Functions
FIGURE 13.5
An inventory listing
The first logical argument, LEFT(B3,3)="202", returns TRUE if the first three characters
of B3 are equal to 202. The second logical argument, MID(B3,5,3)="FIN", returns TRUE if
the three digits starting at the fifth position are equal to FIN. Text manipulation functions
are discussed in Chapter 11.
With the AND function, all logical arguments must return TRUE for the entire function to
return TRUE. If even one of the logical arguments returns FALSE, then the AND function
returns FALSE. Table 13.1 shows the results of the AND function with two logical arguments.
TA B L E 13 .1 A Truth Table for the AND Function
First Logical Argument Second Logical Argument Result of AND Function
TRUE TRUE TRUE
TRUE FALSE FALSE
FALSE TRUE FALSE
FALSE FALSE FALSE
