Discussions

Expand all | Collapse all

How to add an or stipulation to an If function

  • 1.  How to add an or stipulation to an If function

    Posted 07-10-2018 15:18
    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.


  • 2.  RE: How to add an or stipulation to an If function

    Posted 07-10-2018 15:26
    IF(
    [Status] = "completed"
    or 
    [Status] = "delivered", "then result is this", "else result is that")

    the or can be in upper or lower case.