This function checks if a value is a valid email address against certain 2-letter country or region codes and the following top-level domains:
- .com
- .org
- .net
- .edu
- .gov
- .info
If an email is flagged as "False," it may use a top-level domain that isn't on our list.
Sample Usage
ISEMAIL("noreply@google.com")
ISEMAIL("johndoe@yourname.com")
Syntax
ISEMAIL(value)
value
- The value to be verified as an email address.
See Also
ISURL
: Checks whether a value is a valid URL.
ISERROR
: Checks whether a value is an error.
ISTEXT
: Checks whether a value is text.
ISBLANK
: Checks whether the referenced cell is empty.