This article describes how to use the AND function, the syntax around it, and some examples.
Description
Tests to see if all conditions are met.
Syntax for AND function
logical1 AND logical2...Return type
Boolean (TRUE or FALSE)
Example
Case | Returns | Return Type |
|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example in a Complete Formula
Here’s how you would use AND in a complete formula: IF(Country = Country."France" AND Revenue > 1000, "Wow this is crazy good!")
For more information on how the IF function works, see IF.
Excel equivalent: AND(logical1, [logical2], ...)