OR
OR Function
With the use of OR function in excel, we use to test multiple conditions at the same time. It returns either TRUE or FALSE.
Normally the OR() function would be used in conjunction with a function such as =IF().
Syntax
=OR(Test1,Test2)
For example, if we have some students mark in two column, first column mark for physics and 2nd column mark for chemistry. I want to declare pass or fail with use of excel function. If student’s mark is greater than 50 in any subject then pass other wise fail. For this first we will use OR function to find our that any subject has mark is greater than 50. Formula will be =OR(B2>50,C2>50), it will returns true or false then we use if function to get result Pass or Fail. Formula will be =IF(OR(B2>50,C2>50),”PASS”,”FAIL”).
Below video can be viewed for more details about OR function.
Click here to view video for OR Function
