In this article:

Google Sheets IF Multiple Conditions (Easiest way in 2024)

Google Sheets IF Multiple Conditions

In Google Sheets, if you need to evaluate multiple conditions within a single IF statement, you typically combine the IF function with either the AND or OR functions.

Using IF and AND

Syntax: =IF(AND(condition1, condition2, ...), value_if_true, value_if_false)

This formula checks if all specified conditions are true. The AND function returns TRUE if every condition inside it is true. If so, the IF function then returns value_if_true. If any condition is false, the IF function returns value_if_false.

Using IF with OR:

Syntax: =IF(OR(condition1, condition2, ...), value_if_true, value_if_false)

This formula checks if any one of the specified conditions is true. The OR function returns TRUE if at least one of the conditions inside it is true. If so, the IF function returns value_if_true. If all conditions are false, the IF function returns value_if_false.

How to Use IF with AND in Google Sheets

Follow the steps below to use the IF function combined with AND to evaluate multiple conditions simultaneously. We'll apply this to a dataset of student scores in Math and Science to determine if they pass based on achieving minimum scores in both subjects.

1. Determine Specific Conditions to Evaluate

Choose the conditions you need to evaluate. For instance, you're checking if a student has scored at least 70 in Math (A2) and 80 in Science (B2).

google sheets if multiple conditions

2. Start the Formula with the IF Function

Select the result cell and type '=IF(' to initiate the formula. This is where your logical test begins.

3. Incorporate AND Function to Test Multiple Conditions

Inside the IF function, type 'AND(' to start combining your conditions. The AND function will check if all conditions are met.

4. Input Conditions into the AND Function

Type your specific conditions in the AND function. For this example, put 'A2 >= 70' and 'B2 >= 80', separated by a comma.

5. Specify Outcomes for True and False Results

After the conditions, close the AND function with ')', and add outcomes for both true ("Pass") and false ("Fail") scenarios.

6. Complete the Formula by Closing the IF Function

End the formula with a closing parenthesis ')'. The full formula for our example becomes '=IF(AND(A2 >= 70, B2 >= 80), "Pass", "Fail")'.

How to Use IF with OR in Google Sheets

Follow the steps below to use the IF function in conjunction with OR to check if any one of multiple conditions is met. We'll use a dataset containing students' attendance percentages and English scores to determine their qualification based on either high attendance or excellent scores.

1. Identify Any of the Conditions to be Met

Decide on conditions where meeting any one of them is sufficient. Let's say, a student must be present more than 80% of the time (C2) or score above 90 in English (D2).

2. Begin with the IF Function for Logical Test

In the desired result cell, type '=IF('. This starts your logical test using the IF function.

3. Use OR Function for Testing Multiple Possibilities

After IF(, insert 'OR('. The OR function will evaluate if any of your conditions are true.

4. Enter Conditions to be Evaluated by OR

In the OR function, input the conditions. For our case, it's 'C2 > 80%' and 'D2 > 90', each separated by a comma.

5. Define Results for Both True and False Conditions

Close the OR function with ')', and then add what happens if conditions are true ("Qualified") or false ("Not Qualified").

6. Finish the Formula by Closing the IF Function

Conclude with a closing parenthesis ')'. The entire formula for this example is '=IF(OR(C2 > 80%, D2 > 90), "Qualified", "Not Qualified")'.

We hope that you now have a better understanding of how to use Google Sheets IF Multiple conditions.

Use our employee vacation tracker software to easily track employee vacation from your spreadsheet in just a few clicks. 

If you enjoyed this article, you might also like our article on how to use the IFS formula in Google Sheets or our article on how to send bulk emails from Google Sheets. 

If you want to get a copy of our Google Sheets contact list, we also suggest checking out our detailed guide.  

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual 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
When a new row is added to Google Sheets
On new Google Form submission
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
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
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
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started