OR function

Use the OR function, to determine if any conditions in a test are TRUE or not.

=OR(logical1,logical2,……)

Example
If Score1 is greater than 50 OR Score2 equals 100, the OR function returns “True”, otherwise it returns “False”.
=OR(B2>50,C2=100)

• Type “=OR(”
• Click “fx” in the formula bar.
• In “logical1“, click on cell “B2” then type “>50”
• In “logical2“, click on cell “C2” then type “=100”
• Click on “OK”
• Drag from “D2 to D8”