Check Sheet Logo
Check Sheet

ISEMAIL

The ISEMAIL formula is used to check whether a given value is a valid email address or not. It returns TRUE if the value is a valid email address, and FALSE otherwise. This formula is commonly used in data validation to ensure that email addresses entered into a sheet are properly formatted and valid.

Usage

Use the ISEMAIL formula with the syntax shown below, it has 1 required parameter:

=ISEMAIL(value)
Parameters:
  1. value (required):
    The value to be checked for validity as an email address. This can be a cell reference, a text string, or a formula.

Examples

Here are a few example use cases that explain how to use the ISEMAIL formula in Google Sheets.

Data Validation

You can use ISEMAIL to validate email addresses entered into a sheet. By setting up data validation rules that use ISEMAIL, you can ensure that only valid email addresses are entered into specific cells or ranges.

Filtering

You can use ISEMAIL in combination with other formulas, such as FILTER, to filter a list of values and return only those that are valid email addresses.

Conditional Formatting

You can use ISEMAIL to apply conditional formatting to cells containing email addresses. For example, you could format valid email addresses with a green background, and invalid ones with a red background.

Common Mistakes

ISEMAIL not working? Here are some common mistakes people make when using the ISEMAIL Google Sheets Formula:

Incorrect value type for input

The value provided to the ISEMAIL formula must be a string.

Invalid email format

The ISEMAIL formula can only validate email addresses that are in a valid email format. Make sure the email address is entered correctly.

Not supported in all languages

The ISEMAIL formula may not work as expected in all languages. Verify that the formula is supported in your language.

The following functions are similar to ISEMAIL or are often used with it in a formula:

  • ISURL

    The ISURL formula is used to check whether a given value is a valid URL. It returns TRUE if the value is a URL, and FALSE otherwise.

  • ISNUMBER

    The ISNUMBER formula is used to check if a given value is a number. It returns TRUE if the value is a number and FALSE if it is not. This formula is commonly used in data cleaning and validation to identify and remove non-numeric values or to ensure that a cell only contains a number.

  • REGEXMATCH

    The REGEXMATCH formula searches for a regular expression pattern within a specified text string, and returns a boolean value of TRUE if the pattern is found, and FALSE if it is not found. This formula is commonly used to check if a string matches a certain pattern or to extract specific information from a text string based on a pattern.

  • FILTER

    The FILTER formula in Google Sheets is used to filter a range of data based on specified conditions. It returns a new range that only includes the rows that meet the specified conditions. This formula is commonly used to extract specific data from a larger dataset.

  • ARRAYFORMULA

    The ARRAYFORMULA formula in Google Sheets allows for the application of a formula to an entire column or range of data, without needing to manually copy the formula to each cell. It is most commonly used to simplify and automate complex calculations across large data sets.

Learn More

You can learn more about the ISEMAIL Google Sheets function on Google Support.