Home » MCQs » Microsoft Excel MCQs

Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

16. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

1. OR
2. AND
3. IF
4. ANDIF

Answer: B) AND

Explanation:

The AND() function is used to test multiple conditions and returns TRUE if all arguments evaluate TRUE; FALSE if not.

Syntax:

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