Error messages (Xvalidate)

Syntax: Xvalidate_<parameter>

Raise custom error messages based on the value of a mapped field.

1. Define the formula for Xvalidate.

   1. Xvalidate should be used with the IF function. Use the formula's result to determine whether a message is returned.

   2. For example, =IF(A3 < 1000, "Insufficient value", ""), if the value of A3 is less than 1000, return the error message Insufficient value, otherwise "" means not to return an error.

2. Select the cell containing the formula and enter a name in the format of Xvalidate_<parameter>, for example, Xvalidate_eligibility.

Sample file

Xvalidate.xlsx

87KB

Open