OR function in excel
The OR function returns the result (TRUE or FALSE) that any of the provided conditions are true. Syntax =OR([logical1], [logical2], ...)
Example: Here's some sample data to demonstrate it:
We can use this formula in the "Passed (OR)" column:
Excel Formula
=OR(B2>=50, C2>=50, D2>=50)
This checks if the student passed any test (i.e., if their score is greater than or equal to 50). If any test score meets this criterion, the result will be TRUE, otherwise FALSE.
