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