How to add an or stipulation to an If function

  • 0
  • 1
  • Question
  • Updated 5 months 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 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
IF(
[Status] = "completed"
or 
[Status] = "delivered", "then result is this", "else result is that")

the or can be in upper or lower case.