This article describes the formula syntax and usage of the OR function in GoFormz. Use the OR function, one of the logical functions, to return a "true" if any argument is "true"; returns "false" if all arguments are "false".
Syntax
OR(value1, [value2], ...)
The OR function syntax has the following arguments:
- value1, value2, ... value1 is required, subsequent values are optional. 1 to 255 conditions you want to test that can be either "true" or "false".
Remarks
- The arguments must evaluate to logical values, such as "true" or "false"
- If an array or reference argument contains text or empty cells, those values are ignored.
- If the specified range contains no logical values, the field will be left blank.
Example
| Formula | Description | Result |
|---|---|---|
| =OR("true") | One argument is "true" | "true" |
| =OR(1+1=1,2+2=5) | All arguments evaluate to "false" | "false" |
| =OR("true","false","true") | At least one Argument is "true" | "true" |
| =IF(OR(1+1=1,2+2=5,5+5=10),"answer if true","answer if false") | One of the OR arguments is true | answer if true |
Updated almost 2 years ago