Excel Function

AND

Returns TRUE when all conditions are TRUE.

AND(logical1, [logical2], ...)

Arguments

logical1

Required

Enter an expression such as comparison or calculation.

logical2

Optional

Enter an expression such as comparison or calculation.

Practice Preview

show logical evaluation results. Use AND to Returns TRUE when all conditions are TRUE. use C2>=80 for logical1, use D2>=90 for logical2. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=AND(C2>=80, D2>=90)

Practice This Function

Practice in Sequential Mode Back to Function List