Nested IF
What is a Nested IF?
A formula with one IF function inside another IF function.
What does VLOOKUP stand for?
Vertical Lookup.
What is wrong with this formula?
=IF(A1>50,"Pass","Fail"
Missing closing bracket.
Which function would help find a student’s score quickly in a table?
VLOOKUP
How many arguments does VLOOKUP normally use?
4
What does an IF function return when a condition is TRUE?
One value/result.
What part of VLOOKUP tells Excel which column to return data from?
Column Index Number.
Fix this formula:
=IF(A1>=70,Good,Fail)
=IF(A1>=70,"Good","Fail")
Which function is best for assigning grades?
Nested IF
TRUE in VLOOKUP means:
- exact match?
- approximate match?
Approximate match
What grade should this formula return for a score of 88?
=IF(A1>=95,"A",IF(A1>=85,"B","C"))
B
Which value gives an exact match in VLOOKUP?
FALSE (or 0).
What is wrong with this formula?
=VLOOKUP("Bob",A2:B5,2)
Missing FALSE for exact match.
A teacher wants:
Which function should they use?
IF function.
What is the output?
=IF(A1="","Empty","Done")
If A1 has no value
Empty
Write a formula:
=IF(A1>=90,"Excellent","Good")
In this formula, what does the number 3 mean?
=VLOOKUP(H3,B4:E13,3,FALSE)
Return data from the 3rd column.
Fix this Nested IF:
=IF(A1>=90,"A",IF(A1>=80,"B","C")
Missing closing bracket.
A store owner wants to find product prices from a table automatically.
Which function should they use?
VLOOKUP
Write a VLOOKUP formula to find Bob's score from A2:B5.
=VLOOKUP("Bob", A2:B5,2,FALSE)
Why should Nested IF conditions start with the highest value first?
Because Excel checks conditions from top to bottom.
What must always be in the FIRST column of a VLOOKUP table?
The lookup value/search value.
What is wrong with this VLOOKUP?
=VLOOKUP(85,A2:B5,2,FALSE)
The lookup value must be in the first column.
Which function is better for checking MANY conditions: VLOOKUP or Nested IF?
Nested IF
What common mistake happens when quotation marks are missing in IF formulas?
Excel will not recognize the text properly/ formula error.