Forum Discussion

MacyWillis's avatar
MacyWillis
Qrew Member
7 years ago

How to add an or stipulation to an If function

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.
  • IF(
    [Status] = "completed"
    or 
    [Status] = "delivered", "then result is this", "else result is that")

    the or can be in upper or lower case.