How to Use Nested If Statements in Google Sheets

Last Updated on April 13, 2023 by Jake Sheridan

In this tutorial, you will learn how to use nested IF statements in Google Sheets

How to Use Nested If Statements in Google Sheets

If statements are a great way to add custom logic to your spreadsheets. With if statements, you can control the flow of your spreadsheet, and create dynamic formulas that change outputbased on certain conditions.

One way to take control of your spreadsheets is to use nested IF statements. These allow you to create more complex conditions, and evaluate multiple criteria at once.

For example, suppose you want to give a test score a certain letter grade.

We can use the first IF function to check if the score is lower than 60%, then we output a grade of “F”. If this is not the case, our formula will use another IF function to determine if the grade is less than 70% (the threshold for a D) and so on.

In this guide, we will show you how to use nested IF statements in Google Sheets.

How to Use Multiple IF Statements in Google Sheets

Here’s how to use multiple IF statements in Google Sheets.

Step 1

First, select an empty cell to place the formula with our nested IF statements.

In this example, we will construct a formula that will determine whether the student has failed or passed the exam.

We will also consider a particular score range where the student may choose to retake the exam for a chance at a higher grade.

Step 2

Our first IF function checks if our test score is less than 75. If this is true, the formula will output a “FAIL”.

Step 3

Otherwise, another IF statement will be evaluated. This time, we will check if the test score is at less than 78.

If the score is between 75 and 78, the student has passed the test but will be given a chance to retake it in the future.

Step 4

If the score is greater than or equal to 78, then the test score is evaluated as a passing grade.

Step 5

Hit the Enter key to evaluate the nested IF formula.

Summary

This guide should be everything you need to use nested IF statements in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.