You are here:
OR
Determines if expressions are true or false. Returns TRUE if any expression is true. Returns FALSE if all expressions are false.
Use this function as an alternative to the operator || (OR)
Use
OR(logical1,
logical2...) and replace any number of logical references with
the expressions you want evaluated.
Formula Field Example
IF(OR(ISPICKVAL(Priority, "High"), ISPICKVAL(Status, "New")), ROUND(NOW()-CreatedDate, 0),
null)
This formula returns the number of days a case has been open if the Status is new or the Priority is high. If the case was opened today, this field displays a zero.
Validation Rule Example
OR(Sample_Rate__c < 0, Sample_Rate__c > 0.40)This validation rule formula displays this error message when the Sample Rate custom field value isn’t between 0% and 40%: “Sample Rate cannot exceed 40%.”
Did this article solve your issue?
Let us know so we can improve!
