AND to look at multiple conditions and
return a logical value of
TRUE if the conditions
are all true. If any of the conditions are false the function returns
a value of
Logical1, Logical2, ...
The must be between 1 and 30 logical conditions specified. Each condition must evaluate to a value of either
FALSE. For example, A>B.
Figure 19-1 illustrates how AND can be used to
compare two logical conditions and return a value. The example looks
at two logical statements that state the numeric value in column A or
B is less than 5. If both statements are true, as in cell C3, the
function returns a value of
TRUE. You can compare
this to the results of OR which returns a value of
TRUE as long as at least one of the logical
statements is true. Finally, the example illustrates how NOT can be
used to reverse the logical value.
Figure 19-1. Remember with AND all logical conditions must be TRUE to return a value of TRUE; whereas, OR only needs one condition to be TRUE