# How to use The Google Sheets IF AND Function (The Right Way!)

The IF AND function in Google Sheets combines the functionality of the IF and AND functions to create an IF AND statement that is fulfilled if all the stated conditions are met. You can use numeric and string (text) conditions and even combine them together as IF AND conditions to help you identify the entries that you need.

## IF AND Google Sheets Syntax

The IF AND formula syntax is

=IF(AND(condition1, condition2, …), value_if_true, value_if_false)

Where

condition1 and condition2 are the conditions to fulfill. You can set more than two conditions

value_if_true is the value displayed if all the conditions are met

value_if_false is the value displayed if at least one of the conditions are not met

## IF AND Google Sheets Examples

### IF AND with Numeric Conditions

#### 1: Identify the numeric conditions

For this example, we identify the following conditions and values to display:

condition1: Weighted Score is greater than 36

condition2:  Criterion A score is more than 14

Value_if_true: “Excellent”

Value_if_false: “Very Good”

As condition1 relies on data stored in column E and condition2 relies on data stored in column B, we get the following conditions (assuming row 2):

condition1: E2 > 36

condition2:  B2 > 14

#### Step 2: Input the function =IF(AND(condition1, condition2, …), value_if_true, value_if_false)

The function is

=if(and(E2>36,B2>14),"Excellent","Very Good")

#### Step 3: Press Enter.

You can extend IF AND down the column, giving you the following output:

### IF AND with String Conditions

#### Step 1: Identify the string conditions

For this example, we identify two conditions and values to display:

condition1: Assessment A is “Excellent”

condition2: Assessment B is “High Efficiency”

Value_if_true: “Shortlist”

Value_if_false: “Assess further”

As condition1 relies on data stored in column F and condition2 relies on data stored in column G, we get the following conditions (assuming row 2):

condition1: F2=“Excellent”

condition2: G2=“High Efficiency”

The strings should be enclosed in double quotes.

#### Step 2: Input the function =IF(AND(condition1, condition2, …), value_if_true, value_if_false)

The function is

=if(and(F2="Excellent",G2="High Efficiency"),"Shortlist","Assess further")

#### Step 3: Press Enter.

You can extend IF AND down the column, giving you the following output:

### IF AND with both String and Numeric Conditions

#### Step 1: Identify the conditions

For this example, we identify the following conditions and values to display:

condition1: Initial Recommendation is “Shortlist”

condition2:  Criterion D is greater than 14

Value_if_false: "Assess further”

As condition1 relies on data stored in column H and condition2 relies on data stored in column D, we get the following conditions (assuming row 2):

condition1: H2 = “Shortlist”

condition1: D2 > 14

The strings should be enclosed in double quotes.

#### Step 2: Input the function =IF(AND(condition1, condition2, …), value_if_true, value_if_false)

In our example, the function is

#### Step 3: Press Enter.

You can extend IF AND down the column, giving you the following output:

## FAQs

### How many conditions should I use?

There is theoretically no limit in the number of conditions you can add, but the limits come from the conditional logic you want to implement. This puts the realistic limit at to 2-3 conditions.

### Can whole conditions be stored in another cell?

No. However, you can reference other cells when defining conditions.

Absolutely!

### Related IF Functions

IF: Allows you to check for specific conditions across a dataset

SUMIF: Use to sum numbers if they meet a certain condition..

SUMIFS: Sums data from cells that meet multiple criteria

COUNTIF: count data if it fulfils certain criteria

COUNTIFS: Count data that fulfils two or more criteria.

COUNT IF Not Null: Count cells if they contain data

IFS: Allows you to check for multiple if conditions in a single statement

IFERROR: Allows you to output values when an Error in a formula occurs

IFTHEN: Allows you tor write statements that use IF X Then Y Logic

IF ELSE: Evaluates a condition, and takes one action when the result is TRUE and a different one when the result is FALSE.

Multiple IF: Learn how to use multiple if statements in a single formula

IF OR: Evaluates multiple conditions and produces a TRUE result when any of them are met.

IF Contains: Returns cells that contain a particular text.

AVERAGEIF: Calculate an average for numbers within a data range if they meet the provided criteria.

Use our rent reminder app to easily set up custom reminders from your spreadsheet in just a few clicks.

If you want to learn how to attach Google Sheets to email, we also suggest checking out our detailed guide.

# Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL