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

Get Excel 2000 in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.