Use the OR function

Use the OR function to determine if any conditions in a test are TRUE.

Syntax: =OR(formula(s) to test)

Examples:

• =OR(A1<25,A1>75)
  Returns TRUE if the value of A1 is less than 25, or greater than 75. Otherwise it's FALSE.

• =OR(A1="Yes",A1="Maybe",A1="Tentative")
  Returns TRUE if A1 contains the text Yes, Maybe, or Tentative. Otherwise it returns FALSE.

For more info, see OR function.

Use the OR function to determine if any conditions in a test are TRUE.

Syntax: =OR(formula(s) to test)

Examples:

• =OR(A1<25,A1>75)
  Returns TRUE if the value of A1 is less than 25, or greater than 75. Otherwise it's FALSE.

• =OR(A1="Yes",A1="Maybe",A1="Tentative")
  Returns TRUE if A1 contains the text Yes, Maybe, or Tentative. Otherwise it returns FALSE.

For more info, see OR function.

Use the OR function to determine if any conditions in a test are TRUE.

Syntax: =OR(formula(s) to test)

Examples:

• =OR(A1<25,A1>75)
  Returns TRUE if the value of A1 is less than 25, or greater than 75. Otherwise it's FALSE.

• =OR(A1="Yes",A1="Maybe",A1="Tentative")
  Returns TRUE if A1 contains the text Yes, Maybe, or Tentative. Otherwise it returns FALSE.

For more info, see OR function.