Excel 2000 in a Nutshell

Name

AND

Synopsis

Use 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 FALSE.

To Calculate

=AND(Logical1, Logical2, ...)

Logical1, Logical2, ...

The must be between 1 and 30 logical conditions specified. Each condition must evaluate to a value of either TRUE or FALSE. For example, A>B.

Example

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