IF function in Google Sheets - Step-by-Step Guide

Introduction

The IF function helps you make decisions in your spreadsheet. It checks if something is true or false and then shows one result or another. This is useful when you want to sort or label data based on conditions.

When you want to mark students as Pass or Fail based on their scores.

When you need to give discounts only if the purchase amount is above a certain value.

When you want to show 'Yes' or 'No' if a task is completed or not.

When you want to highlight expenses that are over budget.

When you want to check if a date is before or after today.

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 IF formula

💡 Start with =IF(

Step 3: Enter

- the condition inside the parentheses

The condition to check is set, for example A2>50

Step 4: Type

- after the condition, separated by commas

The value to show if the condition is true is added, for example "Pass"

Step 5: Type

- after the true value, separated by a comma

The value to show if the condition is false is added, for example "Fail"

Step 6: Close

- the parentheses and press Enter

The formula calculates and shows the result based on the condition

Before vs After

Before

Column A has scores: 45, 78, 62, 30

After

Column B shows Pass or Fail: Fail, Pass, Pass, Fail based on scores above 50

Settings Reference

Logical_test

📍 Inside the IF formula parentheses

To check if the condition is true or false

Default: No default, must be specified

Value_if_true

📍 Inside the IF formula parentheses after the condition

To show this result when the condition is true

Default: No default, must be specified

Value_if_false

📍 Inside the IF formula parentheses after the true value

To show this result when the condition is false

Default: FALSE

Common Mistakes

Forgetting to put text results in quotes

Google Sheets treats unquoted text as cell references or errors

Always put text values inside double quotes, like "Pass" or "Fail"

Using wrong commas or semicolons as separators

Formula will show an error if separators are incorrect

Use commas to separate arguments in the IF function in Google Sheets

Not closing the parentheses

Formula will not calculate and show an error

Always close the IF function with a closing parenthesis )

Summary

The IF function checks a condition and returns one value if true and another if false.

You must write the condition, the true result, and the false result inside the formula.

Remember to use quotes for text results and commas to separate parts of the formula.

Practice

1. What does the IF function do in Google Sheets?

easy

A. It sorts data alphabetically.

B. It checks a condition and returns one value if true, another if false.

C. It adds two numbers together.

D. It counts the number of cells with numbers.

Solution

1. Step 1: Understand the purpose of IF function

   The IF function tests a condition and chooses between two results based on that test.

2. Step 2: Match the description to the options

   It checks a condition and returns one value if true, another if false. correctly describes this behavior, while others describe different functions.

3. Final Answer:

   It checks a condition and returns one value if true, another if false. -> Option B

4. Quick Check:

   IF function = condition check [OK]

Hint: IF chooses between two results based on a condition [OK]

Common Mistakes:

• Thinking IF adds or counts values
• Confusing IF with sorting functions
• Ignoring the true/false result structure

2. Which of these is the correct syntax for the IF function in Google Sheets?

easy

A. =IF(value_if_true, condition, value_if_false)

B. =IF(condition; value_if_false; value_if_true)

C. =IF(condition, value_if_true, value_if_false)

D. =IF(condition value_if_true value_if_false)

Solution

1. Step 1: Recall the IF function syntax

   The correct order is: condition, value if true, value if false, separated by commas.

2. Step 2: Compare options to syntax

   =IF(condition, value_if_true, value_if_false) matches the correct syntax exactly. Others have wrong order, separators, or missing commas.

3. Final Answer:

   =IF(condition, value_if_true, value_if_false) -> Option C

4. Quick Check:

   Syntax = condition, true, false [OK]

Hint: Remember: IF(condition, true_result, false_result) [OK]

Common Mistakes:

• Swapping true and false results
• Using semicolons instead of commas
• Omitting commas between arguments

3. Given cell A1 contains 75, what is the result of =IF(A1>50, "Pass", "Fail")?

medium

A. "Pass"

B. "Fail"

C. 75

D. TRUE

Solution

1. Step 1: Evaluate the condition A1>50

   Since A1 is 75, which is greater than 50, the condition is TRUE.

2. Step 2: Determine the IF function output

   Because the condition is TRUE, the function returns the value_if_true, which is "Pass".

3. Final Answer:

   "Pass" -> Option A

4. Quick Check:

   75 > 50 = Pass [OK]

Hint: Check condition first, then pick true or false result [OK]

Common Mistakes:

• Returning the cell value instead of the IF result
• Confusing true and false outputs
• Ignoring the comparison operator

4. The formula =IF(A2=100, "Yes", "No" is entered in a cell. What is wrong with it?

medium

A. Missing closing parenthesis at the end.

B. Wrong comparison operator used.

C. The true and false results are reversed.

D. The formula uses quotes incorrectly.

Solution

1. Step 1: Check the formula syntax

   The formula is missing a closing parenthesis at the end, which is required to close the IF function.

2. Step 2: Verify other parts of the formula

   The comparison operator (=) and the true/false results are correct, and quotes are properly used around text.

3. Final Answer:

   Missing closing parenthesis at the end. -> Option A

4. Quick Check:

   Syntax error = missing parenthesis [OK]

Hint: Count your parentheses to avoid syntax errors [OK]

Common Mistakes:

• Forgetting to close parentheses
• Mixing up = and == operators
• Misplacing quotes around text

5. You want to mark students as "Passed" if their score in cell B2 is 60 or more, and "Failed" otherwise. Which formula correctly does this?

hard

A. =IF(B2=60, "Passed", "Failed")

B. =IF(B2>60, "Passed", "Failed")

C. =IF(B2<60, "Passed", "Failed")

D. =IF(B2>=60, "Passed", "Failed")

Solution

1. Step 1: Understand the passing condition

   Students pass if their score is 60 or more, so the condition should be B2 >= 60.

2. Step 2: Check each option's condition

   =IF(B2>=60, "Passed", "Failed") uses >= 60, which matches the requirement. =IF(B2>60, "Passed", "Failed") excludes 60, the one with <60 reverses pass/fail logic, and the one with =60 only passes exactly 60.

3. Final Answer:

   =IF(B2>=60, "Passed", "Failed") -> Option D

4. Quick Check:

   Score >= 60 = Passed [OK]

Hint: Use >= for '60 or more' condition [OK]

Common Mistakes:

• Using > instead of >= to include 60
• Reversing pass and fail results
• Checking only for equality (=60)