OR Function Explained

The OR function in Microsoft Excel is used to test multiple conditions at the same time and returns TRUE if any of the conditions are met. It takes two or more logical arguments as input and returns a Boolean value. For example, =OR(A1="Yes", B1="Yes") will return TRUE if either cell A1 or B1 contains the value “Yes”.

OR Function Syntax

OR(logical1, [logical2], ...)

  • logical1: The first logical value or expression to evaluate.
  • logical2: (optional) Additional logical values or expressions to evaluate.