ITPEC IP October 2024 Question 17

The formula must return Pass when any one of the three passing conditions is true, so it uses OR and places Pass in the true branch. The conditions are (A2+B2) ≥ 120, A2 = 100, and B2 = 100. Therefore the appropriate form is IF(OR(...), 'Pass', 'Fail').

For the displayed scores, 50 + 80 = 130, so the first condition is true and the result is Pass even though neither individual score is 100.

Answer (c)

Why not others:
- (a) requires all three criteria simultaneously because it uses AND
- (b) also uses AND and reverses the output values
- (d) has the correct OR condition but returns Fail when it is true

Key rule: Use OR when satisfying any listed criterion is enough; the second IF argument is returned when the condition is true.

AI-generated — may contain errors