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