Nested IF functions in Google Sheets - Step-by-Step Guide

Introduction

Nested IF functions help you check multiple conditions one after another in a single formula. This is useful when you want to give different results based on several rules, like grading scores or categorizing data.

When you want to assign letter grades based on numeric scores, like A, B, C, etc.

When you need to categorize sales amounts into ranges like low, medium, and high.

When you want to check if a date falls into different time periods and return labels.

When you want to apply different discounts based on purchase quantity tiers.

When you want to display different messages based on multiple conditions in a survey.

Steps

Step 1: Click

- the cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the formula bar

You start entering the formula

💡 Begin with =IF(condition1, value_if_true1, IF(condition2, value_if_true2, value_if_false2))

Step 3: Enter

- the full nested IF formula, for example: =IF(A1>90, "A", IF(A1>80, "B", IF(A1>70, "C", "F")))

The formula checks the first condition; if false, it checks the next, and so on

Step 4: Press

- Enter key

The cell shows the result based on the first true condition or the last value if none are true

Step 5: Copy

- the cell with the nested IF formula

You can paste it to other cells to apply the same logic to other data

Before vs After

Before

Cell A1 has a score of 85, and cell B1 is empty

After

Cell B1 shows "B" after entering =IF(A1>90, "A", IF(A1>80, "B", IF(A1>70, "C", "F")))

Settings Reference

Formula input

📍 Formula bar at the top of the sheet

Where you type your nested IF formula

Default: Empty

Cell format

📍 Format menu > Number

Controls how the result of the formula is displayed

Default: Automatic

Common Mistakes

Forgetting to close all parentheses in the nested IF formula

Google Sheets shows an error because the formula is incomplete

Count and match each opening parenthesis '(' with a closing one ')'

Using incorrect logical conditions like =IF(A1>90, "A", IF(A1>80, "B", "C")) without covering all cases

Some values might not fit any condition and give unexpected results

Make sure the last value_if_false covers all remaining cases

Typing text values without quotes inside the formula

Google Sheets treats unquoted text as invalid and shows an error

Always put text results inside double quotes, like "A" or "Low"

Summary

Nested IF functions let you test multiple conditions in one formula.

Each IF checks a condition and moves to the next if false.

Remember to close all parentheses and use quotes for text results.