ISEMAIL Function in Google Sheets

Verify if a value is a valid email address using the ISEMAIL function.

ISEMAIL Function

The ISEMAIL function in Google Sheets is used to check if a given value is a valid email address.

Syntax

ISEMAIL(value)
  • value: The value you want to check for being a valid email address. This is a required parameter.

Example

  1. Check If Value is an Email

Verify if “[email protected]” is a valid email address:

=ISEMAIL("[email protected]")

This will return TRUE.

Notes

  • The function checks for common email formatting issues but may not verify actual domain existence.
  • ISNUMBER: Check if a value is a number.