How to add an or stipulation to an If function

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I need to create an "if" formula, but need the "if" part to be this -  "If the status is equal to either completed OR delivered." I can't figure out how to create the OR function within the formula.
Photo of Macy Willis

Macy Willis

  • 90 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
[Status] = "completed"
[Status] = "delivered", "then result is this", "else result is that")

the or can be in upper or lower case.