Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The ISVALID function is used to validate if a ZA ID number is a valid South African ID number, or if an email address is a correct and valid email address.
Syntax
ISVALID(validator, value)
The ISVALID function syntax has the following arguments:
- validator - Required. The validator to use, i.e. "email" or "za-id".
- value - Required. The value to test.
Example
| Formula | Description | Result |
| =ISVALID(za-id, 7903135098083) | Checks whether "7903135098083" is a valid ZA ID number | TRUE |
| =ISVALID(email, cedric@gmail.com) | Checks whether "cedric@gmail.com" is a valid email address | TRUE |
| =ISVALID(za-id, 123) | Checks whether "123" is a valid ZA ID number | FALSE |
Errors
For a full list of formula errors, please read Formula errors.