Comparison Functions

Return values based on logical operations.

Comparison Function	Description
AllAreFalse	The AllAreFalse function returns true if all of the provided conditions is false. Otherwise false.
AllAreTrue	Returns true if all of the provided conditions are true. Otherwise false.
AnyAreFalse	The AnyAreFalse function returns true if any of the provided conditions is false. Otherwise false.
AnyAreTrue	Returns true if any of the provided conditions are true. Otherwise false.
EqualTo	Returns true if two expressions are equal.
GreaterThan	Returns true if the first expression is greater than the second expression.
GreaterThanOrEqual	Returns true if the first expression is greater than or equal to the second expression.
If	The If function returns one of two values, depending on a given condition.
IfCase	The IfCase function compares a test value against a list of values, returning the result from the first matching pair.
IfChain	The IfChain function returns the return value from the first true condition in a list.
Instr	The Instr function returns the position of the first occurrence of one string within another string.
IsBetween	Returns true if a value is equal to or between two boundary values.
IsClassification	Returns true the given field meets the criteria to belong to the given classification.
IsMatch	Determines if a given value is found in a list of values.
IsNotNullOrEmpty	The IsNotNullOrEmpty function returns true if a field is not null or empty.
IsNull	The IsNull function returns true if a field is null.
IsNullOrEmpty	The IsNullOrEmpty function returns true if a field is null or empty.
IsNumeric	Returns true if a value is or can be converted to a number without error.
Largest	Returns the largest value in a list of values.
LessThan	Returns true if the first expression is less than the second expression.
LessThanOrEqual	Returns true if the first expression is less than or equal to the second expression.
NoneAreFalse	The NoneAreFalse function returns true if none of the provided conditions is false. Otherwise false.
NoneAreTrue	The NoneAreTrue function returns true if none of the provided conditions is true. Otherwise false.
NotEqualTo	Return true if two expressions are not equal.
NotEqualTo	Return true if two expressions are not equal.
NumberOfFalse	The NumberOfFalse function returns the number of provided conditions that evaluate as false.
NumberOfTrue	The NumberOfTrue function returns the number of provided conditions that evaluate as true.
NumFracDigits	Returns the number of digits in a given number that appear to the right of the decimal point, not counting trailing zeros.
NumIntDigits	Returns the number of digits in a given number that appear to the left of the decimal point, not counting preceding zeros.
Smallest	Returns the smallest value from a list of values.