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.
Forum Discussion
IF(
[Status] = "completed"
or
[Status] = "delivered", "then result is this", "else result is that")
the or can be in upper or lower case.
[Status] = "completed"
or
[Status] = "delivered", "then result is this", "else result is that")
the or can be in upper or lower case.