Home » MCQs » Microsoft Excel MCQs

Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?

17. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?

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

Answer: A) OR

Explanation:

The OR() function is used to test multiple conditions and returns TRUE if one or more evaluates to TRUE, and returns FALSE if all arguments evaluate to FALSE.

Syntax:

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