Skip to main content
Question

How to add an or stipulation to an If function

  • July 10, 2018
  • 0 replies
  • 29 views
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.
    This topic has been closed for replies.

    IF(
    [Status] = "completed"
    or 
    [Status] = "delivered", "then result is this", "else result is that")

    the or can be in upper or lower case.
    Terms & ConditionsAccessibility statement