Excel AND Function

Use:

Evaluates the logical and operation for multiple T/F comparisons. The result is true if all of the individual comparisons are true. The result is false if at least one of the individual comparisons is false.

Syntax:

AND( test-1 , test-2 , ... )

Examples:

AND( D12 > 500 , D12 < 750 )

AND( A1 < A2 , A2 < A3 , A3 < A4 , A4 < A5 )

AND( F12 <> "John Mote" , F12 <> "Ted Williams" )

Related Functions:

IF, OR