It is designed to test multiple conditions simultaneously and return TRUE ifanycondition is TRUE.
Ifallconditions are FALSE, the OR function returns FALSE.
The OR function is a good way to simplify complicated formulas use manynested IFs.
Each “logical” is a condition that can be evaluated as TRUE or FALSE.
The arguments provided to the OR function can be constants, cell references, or logical expressions.
Notice that text values used in comparisons must be enclosed in double quotes ("").
If both scores are 750 or above, the result should be “Approve”.
Example - IF this OR that
The worksheet below is a variation of the example above.
The formula in cell D5 is:
You are free to replace “x” with any other value.
Notice that the OR function isnot case-sensitive.
Example - OR with a range
It is possible to use OR with a range of values.
In Excel 2021 or later, the formula “just works” without special handling.
In the example above, the AND function is used inside the IF function as the logical test.
This formula will return “Pass” only if the score for all six subjects is greater than 65.
Otherwise, the result is “Fail”.
See alsoMust pass 4 out of 6 subjects.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
More than one condition can be tested by nesting IF functions.
The IF…
XOR Function
The XOR function performs what is called “exclusive OR”.
If neither is TRUE, XOR also returns FALSE.
NOT Function
The Excel NOT function returns the opposite of a given logical or Boolean value.
When given TRUE, NOT returns FALSE.
When given FALSE, NOT returns TRUE.
Use the NOT function to reverse a logical value.
