To check if a value is a valid email address, use the ISEMAIL function. This checks if the value follows a commonly accepted format for email addresses but doesn’t verify its existence.
Sample Usage
ISEMAIL("noreply@google.com")
ISEMAIL("johndoe@yourname.com")
ISEMAIL("janesmith@yourname.xyz")
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.