What is the use of EXCEL OR Function in Excel?

Data Science, AI and ML
,
#1

The Excel OR function returns TRUE if any given argument evaluates to TRUE, and returns FALSE if all supplied arguments evaluate to FALSE. For example, to test A1 for either “x” or “y”, use =OR(A1=“x”,A1=“y”). The OR function can be used as the logical test inside the IF function to avoid nested IFs, and can be combined with the AND function.

  • Purpose: Test multiple conditions with OR

  • Return value: TRUE if any arguments evaluate TRUE; FALSE if not.

  • Syntax

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

Arguments

  • logical1 - The first condition or logical value to evaluate.
  • logical2 - [optional] The second condition or logical value to evaluate.

Example:

For example, to test if the value in A1 OR the value in B1 is greater than 75, use the following formula:


=OR(A1>75,B1>75)

OR can be used to extend the functionality of functions like the If Function. Using the above example, you can supply OR as the logical_test for an IF function like so:

=IF(OR(A1>75,B1>75), "Pass", "Fail")