OR function

The OR function returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

The syntax is:

OR(logical1, [logical2], ...)

Notes

  • The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values.
  • If an array or reference argument contains text or empty cells, those values are ignored.

 

IF function

The IF functions returns one value if a condition is true and another value if it is false.

The syntax is:

IF(logical_test,value_if_true,value_if_false)
  • “logical_test” is the condition you want to test.
  • “value_if_true” is the value you want returned if the test is true
  • “value_if_false” is the value you want returned if the test is false

For example:

=IF(Field_ID1>Field_ID2,"Over Budget","OK")

 

AND function

The AND function returns TRUE if all its arguments evaluate to TRUE. It returns FALSE if one or more arguments evaluate to FALSE.

One common use for the AND function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the AND function as the logical test argument of the IF function, you can test many different conditions instead of just one.

The syntax is:

AND(logical1, [logical2], ...)

Notes

  • The arguments must evaluate to logical values, such as TRUE or FALSE, or the arguments must be arrays or references that contain logical values.
  • If an array or reference argument contains text or empty cells, those values are ignored.
  • If the specified range contains no logical values, the AND function returns the #VALUE! error value.

 

CONTAINS function

The CONTAINS function finds if one or more given items is selected in a checkbox field passed as the first parameter.

=contains(Checkbox_FieldID,"A","B","C")

The function will return a value of 1 any of the options A, B, or C are selected in the Checkbox field. If none of the options are present, it will return a value of 0.

NOTE: Contains is not like substring. It should match the exact value (case insensitive).
 

CONTAINSALL function

The CONTAINSALL function finds if all of the given items are selected in the checkbox field passed as the first parameter.

=containsAll(Checkbox_FieldID,"A","B","C")

The function will return a value of 1 if all of the options A, B, and C are selected in the Checkbox Field. If this condition is not met, the function will return 0. 

It will also return a value of 1 if other values in addition to A, B, and C are selected (i.e., A, B, C, D, and E).


CONTAINSONLY function

The CONTAINSONLY function finds if only the given items and no other items are selected in the checkbox passed as the first parameter.

=containsOnly(Checkbox_FieldID,"A","B","C")

The function will return a value of 1 if options A, B, and C are selected in the Checkbox Field. It will return a value of 0 if not all of the items are selected, or if additional items are selected apart from the parameters. 

Did this answer your question?