If [If]

Return to Complete List of Functions

The If function returns a given value if a condition is true and a different value if the condition is not true. Parameters ------------------ Condition          The condition to evaluate. Value If True    The value to return when the condition is true (non-zero). Value If False   The value to return when the condition is false (zero). The condition and values can be any combination of raw data, calculated values, or constants. Function Value ------------------------ This function returns the "Value If True" if a condition is true and the "Value If False" if the condition is not true. A condition is considered to be true if it has a non-zero valuel. If the condition is null, a null is returned.