IF basics
Real-life IF
Nested IF
COUNTIF
Fix the Formula
100

What does the IF function do?


It tests a condition and returns one value if TRUE and another if FALSE.

100

IF it is raining → take an umbrella.
What is the condition?

“It is raining”

100

What is a Nested IF?


An IF function inside another IF function.

100

What does COUNTIF do?


Counts cells that meet one condition.

100

What is wrong with this formula?
=IF(A1>50 Pass Fail)

Missing commas and quotation marks.

=IF(A1>50,"Pass","Fail")

200

What are the 3 parts of an IF function?


Logical test, value if true, value if false.

200

IF score is above 70 → Pass.
IF NOT → Fail.
What happens if the score is 65?

Fail

200

How many conditions can a Nested IF check?


More than one condition.

200

What is the syntax of COUNTIF?

=COUNTIF(range, criteria)

200

Fix this formula:
=COUNTIF(A1:A10,>50)

=COUNTIF(A1:A10,">50")

300

Write the correct syntax for an IF function.


=IF(logical_test, value_if_true, value_if_false)

300

Give one real-life example of IF logic.


  • If traffic light is green → go
  • If homework is done → play games 
  • etc.
300

What does this formula return if A1 = 95?
=IF(A1>=90,"Excellent",IF(A1>=70,"Good","Needs Improvement"))

“Excellent”

300

What does this formula count?
=COUNTIF(A1:A10,">50")

Cells with numbers greater than 50.

300

What is missing?
=IF(B2>=70,"Pass","Fail"

Closing bracket 

400

What result would this formula return?

=IF(8>5,"Yes","No")


“Yes”

400

TRUE or FALSE:
An IF statement can only have two outcomes.

TRUE

400

What does this formula return if C3 is blank?
=IF(C3="","Incomplete",IF(C3>=65,"Pass","Fail"))

“Incomplete”

400

TRUE or FALSE:
COUNTIF can only test one condition.

TRUE

400

Fix the Nested IF:
=IF(A1>=90,"A",IF(A1>=70,"B","C"

=IF(A1>=90,"A",IF(A1>=70,"B","C"))

500

What result would this formula return?
=IF(10<3,"Hot","Cold")

“Cold”

500

Which operator means “greater than or equal to”?


>=

500

Why should the highest condition usually come first in a Nested IF?


Because Excel checks conditions from top to bottom.

500

Which wildcard matches any number of characters?


*

500

What is wrong with this formula order?
=IF(A1>=70,"Good",IF(A1>=90,"Excellent","Needs Improvement"))

The conditions are in the wrong order. 90 should come before 70.

=IF(A1>=90,"Excellent",IF(A1>=70,"Good","Needs Improvement"))

M
e
n
u