# How to Use ISEMAIL Function in Google Sheets

The ISEMAIL function in Google Sheets is used to determine if a value is a valid e-mail address.

This function is useful because it helps you see if a value in a certain cell contains an email address that can be sent a message online. Even if they do not take on the typical appearance of a link, i.e. underlined blue font, Google Sheets can still determine if they lead to an e-mail.

Let’s look at an example.

You have a spreadsheet that details the information on your B2B customers. You want to have a column that details their company e-mail, but the information skips per line item and you want to have a surefire way to know if you have to update their contact detail in your marketing list.

The `ISEMAIL` function takes in the text input to determine if it contains an e-mail address or not. Instead of scanning the entire document, using this function can be helpful.

## The Anatomy of ISEMAIL Function in Google Sheets

The syntax of the `ISEMAIL` function is as follows:

`=ISEMAIL(value)`

Let’s have a look at each part of the function to understand what is going on here:

• `=` is the equals sign that starts off any function in Google Sheets.
• `ISEMAIL` is the name of our function.
• `value` is the value to be verified as an e-mail address.

Note that Google Sheets automatically makes hyperlinked emails to valid e-mail addresses.

will all return `TRUE` if you use the `ISEMAIL` function on these values.

## A Real Example of Using ISEMAIL Function

Let’s look at the example below to see how to use `ISEMAIL` function in Google Sheets.

#### Determining E-mail Address Validity in Google Sheets

This is a simple problem. We want to know if a text is a valid e-mail address or not.

The function takes just one argument. So in the equation, it will look like:

`=ISEMAIL(D3)`

As a result, we get TRUE.

This simple problem can be practiced to perfection. Use the link below to get a copy of this problem set:

## How to Use ISEMAIL Function in Google Sheets

In this section, we will show you a step-by-step process on how to use the `ISEMAIL` function in Google Sheets.

In this problem, we will look through the emails in a spreadsheet column. To make the search easier, will use the function alongside Conditional Formatting.

#### Determining E-mail Validity in Google Sheets with Conditional Formatting

1. To begin, prepare your spreadsheet with the e-mails you want to check. For this example, we removed the blue color text and underline to illustrate the function.

1. Highlight the cells that you want to know are e-mails or not.

1. From the Menu Bar, choose Format. Scroll to the bottom of the list and choose “Conditional formatting.

1. This will open in the Conditional Formatting menu.

1. It’s time to create a Format rule. From the dropdown list under “Format cells if…” scroll all the way to the bottom and choose “Custom formula is

1. Next, we will use the `ISEMAIL` function to highlight the correct cells. Insert `=ISEMAIL(D3)`, with Cell D3 being the first cell in the list.

1. Click done, and you will see the new conditional format rule that you created.

1. Now, you can see which items are valid e-mails. That’s it – you are now done!

The `ISEMAIL` function can help tidy up your spreadsheet and point out any missing information or mistakes. This should definitely help you avoid mistakes in your spreadsheets in the future, too.

And there you have it – you can now use the `ISEMAIL` function in Google Sheets together with the other numerous Google Sheets formulas to create even more effective formulas.

### Get emails from us about Google Sheets.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'll love what we are working on! Readers receive ✨ early access ✨ to new content. There will be no spam and you can unsubscribe at any time.

## How to Create a Dependent Drop Down List in Google Sheets

Learning how to create a dependent drop-down list in Google Sheets is useful to create several lists of…

## How to Use PROPER Function in Google Sheets

The PROPER function in Google Sheets is useful if you want to capitalize words on a given text…

## How to Create a Radial Bar Chart in Google Sheets

The radial bar chart in Google Sheets is useful for creating eye-catching visualizations of differences among certain categories.…

## How to Use COUPPCD Function in Google Sheets

This guide will explain how to use the COUPPCD function in Google Sheets. Coupon payments refer to the…