ALL

The ALL function evaluates a series of conditions and returns "true" if they all evaluate to "true"; otherwise returns "false".

Syntax:
ALL (series-condition-expression)
Meaning:
ALL (conditions_to_evaluate)
Returns:
True or false

The ALL function evaluates to "true" if all members of the input argument evaluate to "true".; it evaluates to "false" if any member of the input argument is "false".

Examples

  • You can use ALL when you want to test whether all conditions of a series are true.
  • PO (s)=IF (ALL( PO#:Line:Order = PO#:Line:Order[1]), Order, "none")

    If each and every PO# matches the PO# of the first Order, ALL evaluates to "true". Otherwise, ALL evaluates to "false".

Related functions

  • NOT
  • OR