IF function in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the IF function do in Google Sheets?

The IF function checks if a condition is true or false. It returns one value if true, and another if false.

beginner

Write the basic syntax of the IF function.

IF(condition, value_if_true, value_if_false)<br>Example: IF(A1>10, "Yes", "No")

beginner

How would you use IF to check if a number in cell B2 is greater than 100 and return "High" or "Low"?

Use: IF(B2>100, "High", "Low")<br>This means if B2 is more than 100, show "High", otherwise show "Low".

intermediate

Can the IF function be nested inside another IF function? What is this used for?

Yes, nesting IFs means putting one IF inside another. It helps check multiple conditions step by step.

beginner

What happens if you leave the value_if_false part empty in an IF function?

If value_if_false is empty, the IF function returns FALSE when the condition is not met.

What will the formula =IF(A1=5, "Yes", "No") return if A1 contains 5?

A FALSE

B "No"

C 5

D "Yes"

Since A1 equals 5, the condition is true, so the formula returns "Yes".

Which part of the IF function is checked first?

A value_if_true

B value_if_false

C condition

D None

The condition is checked first to decide which value to return.

What does this formula return if B2 is 50? =IF(B2>100, "High", "Low")

A "Low"

B "High"

C 50

D TRUE

Since 50 is not greater than 100, the formula returns "Low".

How do you write an IF function that returns TRUE if C3 is empty?

A IF(C3="", TRUE, FALSE)

B IF(C3, TRUE, FALSE)

C IF(C3=TRUE, "", FALSE)

D IF(C3=FALSE, TRUE, FALSE)

Checking if C3 equals an empty string "" tests if the cell is empty.

What will =IF(10>5) return in Google Sheets?

A TRUE

B Error

C FALSE

D 10&gt;5

IF requires at least two arguments: condition and value_if_true. Omitting value_if_false is allowed and returns FALSE if condition is false. However, missing value_if_true causes an error.

Explain how the IF function works and give a simple example.

Think about checking a question and choosing between two answers.

Describe how you can use nested IF functions to check multiple conditions.

Imagine asking several yes/no questions one after another.