Logical Function in Excel: OR Function

June 02, 2013

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

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”.

No comments

Share your thoughts

%d bloggers like this: