The IF formula: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

If A1 = 45, what will this formula return?
=IF(A1>=40,"Pass","Fail")
- A. Fail
- B. 40
- C. Pass
- D. 45
Show the answer
C — Pass. 45 is 40 or more, so IF gives the first answer: Pass.
If A1 = 25, what will this formula return?
=IF(A1>50,"High","Low")
- A. High
- B. Low
- C. 50
- D. 25
Show the answer
B — Low. 25 is not more than 50, so IF gives the second answer: Low.
If A1 = 100 and B1 = 80, what will this formula return?
=IF(A1>B1,A1-B1,0)
- A. 180
- B. 100
- C. 20
- D. 0
Show the answer
C — 20. 100 is more than 80, so IF works out A1-B1, which is 20.
If A1 is empty, what will this formula return?
=IF(A1="","Missing","OK")
- A. 0
- B. Missing
- C. OK
- D. An error
Show the answer
B — Missing. "" means empty. A1 is empty, so IF gives Missing.
If A1 = 50, what will this formula return?
=IF(A1>=50,"Yes","No")
- A. TRUE
- B. No
- C. 50
- D. Yes
Show the answer
D — Yes. >= means more than or equal to. 50 is equal to 50, so the answer is Yes.