Logical Function in Excel: OR Function
OR Function checks one or more given Logical Criteria and if any of the given logical criteria is true the return a Value of True, otherwise false.
Syntax of OR Function
= Or (logical1, logical2, ... )
Example of OR Function
In the above example, marks obtain in two subjects is given and passing marks in each of the subject is 30. If a student able to score passing marks in any of the subject that is score more than 30 marks (any Marks in Col. C or Col. D for the corresponding student is greater than 30) then it return “True”, and if No of the Marks in Col. C or Col. D for the corresponding student is greater than 30 then it will give a value “False”.