IF function in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the IF function do in Excel?

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.

The syntax is: =IF(condition, value_if_true, value_if_false).

beginner

How would you use IF to check if a number in cell A1 is greater than 10?

Use =IF(A1>10, "Yes", "No"). It shows "Yes" if A1 is more than 10, otherwise "No".

beginner

Can the IF function return text values? Give an example.

Yes. Example: =IF(B1="Pass", "Well done", "Try again") returns text based on B1's value.

intermediate

What happens if the condition in IF is false and you leave value_if_false empty?

Excel returns FALSE by default if value_if_false is missing.

What will =IF(5 > 3, "Yes", "No") return?

A 3

B "No"

C "Yes"

D 5

5 is greater than 3, so the condition is true and the function returns "Yes".

Which part of IF function is the condition to check?

A condition

B value_if_false

C value_if_true

D result

The first part inside IF is the condition that Excel tests.

What does =IF(A1=10, 100, 0) do?

A Returns 10 if A1 equals 100, else 0

B Returns 100 if A1 equals 10, else 0

C Returns 0 if A1 equals 10, else 100

D Always returns 100

It checks if A1 is 10; if yes, returns 100; otherwise returns 0.

Can IF function be used to return numbers?

A Yes, it can return numbers or text

B Only logical TRUE or FALSE

C No, only text

D Only dates

IF can return any value, including numbers, text, or logical values.

What will =IF(FALSE, "Yes", "No") return?

A "Yes"

B FALSE

C TRUE

D "No"

Since the condition is FALSE, IF returns the value_if_false, which is "No".

Explain how the IF function works in Excel with an example.

Think about checking if a number is bigger than another.

Describe a real-life situation where you could use the IF function in a spreadsheet.

Consider grading students or checking sales targets.