Use the OR function to determine if any conditions in a test are TRUE.
Example 1: Returns TRUE if the value of A1 is less than 25, or greater than 75. Otherwise it returns FALSE.
=OR(A1<25,A1>75)
Example 2: Returns TRUE if A1 contains the text Yes, Maybe, or Tentative. Otherwise it returns FALSE.
=OR(A1="Yes",A1="Maybe",A1="Tentative")
For more info, see OR function.
Use the OR function to determine if any conditions in a test are TRUE.
Example 1: Returns TRUE if the value of A1 is less than 25, or greater than 75. Otherwise it returns FALSE.
=OR(A1<25,A1>75)
Example 2: Returns TRUE if A1 contains the text Yes, Maybe, or Tentative. Otherwise it returns FALSE.
=OR(A1="Yes",A1="Maybe",A1="Tentative")
For more info, see OR function.