by The OR function in Microsoft Excel comes under the logical function category. The OR function is also used to test multiple conditions at a time just like the AND Function.
This function also gives the result in True or False. If all the conditions are satisfied in the IF function, and if any one of the multiple conditions given in the OR function is true, then it returns TRUE. And it will return FALSE only when all the conditions are false.
Syntax-
=OR(logical1,[logical2],[logical3],[logical4],……)
Arguments-
logic 1 – to test the first condition or logic value.
logic 2 – to test the second condition value.
Example: If Function will return True when it is greater than 70 in Test 1 and either it is equal to 100 in Test 2 then only True will come otherwise False will come.
