Learn Excel EasyDaily One Lesson

Quiz › Formulas & Functions › AND, OR and nested IF

AND, OR and nested IF: Excel Quiz

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

  1. A1 = 60 and B1 = 40. What will this formula return?
    =IF(AND(A1>=50,B1>=50),"Pass","Fail")
    • A. TRUE
    • B. FALSE
    • C. Fail
    • D. Pass
    Show the answerC — Fail. AND needs both to be 50 or more. B1 is 40, so: Fail.
  2. A1 = 60 and B1 = 40. What will this formula return?
    =IF(OR(A1>=50,B1>=50),"Pass","Fail")
    • A. Fail
    • B. FALSE
    • C. Pass
    • D. TRUE
    Show the answerC — Pass. OR needs only one to be 50 or more. A1 is 60, so: Pass.
  3. A1 = 75. What will this formula return?
    =IF(A1>=90,"A",IF(A1>=70,"B","C"))
    • A. 75
    • B. B
    • C. C
    • D. A
    Show the answerB — B. 75 is not 90 or more, but it is 70 or more, so: B.
  4. A1 = 10. What will this formula return?
    =AND(A1>5,A1<8)
    • A. FALSE
    • B. 10
    • C. An error
    • D. TRUE
    Show the answerA — FALSE. 10 is more than 5 but not less than 8, so AND gives FALSE.
  5. A1 = 95. What will this formula return?
    =IF(A1>=90,"A",IF(A1>=70,"B","C"))
    • A. 95
    • B. C
    • C. B
    • D. A
    Show the answerD — A. 95 is 90 or more, so IF stops at the first answer: A.

Want to learn this? Read the Formulas & Functions lessons →
← More Formulas & Functions topics · All quiz categories