Use the 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.

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.