Skip to content
Google Sheets

ISEMAIL function in Google Sheets

Checks whether a value is a valid email address.

=ISEMAIL(value)

ISEMAIL syntax and parameters

One argument, one required.

  • valueanyRequired

    The value to be verified as an email address.

ISEMAIL examples

Formulas you'll actually reuse.

  1. Is the address in B2 well-formed?

    =ISEMAIL(B2)

    ResultTRUE

  2. Every customer whose email needs fixing:

    =FILTER(A2:B200, NOT(ISEMAIL(B2:B200)))

ISEMAIL in Excel

No direct equivalent — here's the way around.

Try ISEMAIL in the playground

Edit the example — nothing to install.

Preloaded with the ISEMAIL formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.