OR

Logically OR is used to evaluate boolean conditions. It returns true if any of the listed conditions are true, and false if they are all false.

Syntax

bool? OR(params bool?[] conditions)

Example

OR(COMPARE("Apples","apples", true))

This is combining the COMPARE function, which is asking is "Apples" the same as "apples" when the case is ignored. As this is correct OR returns true.

---

Take for example you want to check if a column contains a value, each column you check might need a different value to be returned in this case you can pass what value the function should check for:

OR(Column1 == "value1", Column2 == "value2", Column3 == "value3")