IF function practice exercises (with AND, OR and IFS)

The logic functions, with examples

Every example runs on class-results.xlsx, the same sheet the exercises use, and the results are calculated from that data.

• IF

  Full guide →

  Checks a condition and returns one value if it's TRUE and another if it's FALSE.

  IF(logical_test, value_if_true, [value_if_false])

  Example

  =IF(B2>=50, "Pass", "Fail")→returnsPass

• AND

  Full guide →

  Returns TRUE only when every condition is TRUE. Usually used inside IF.

  AND(logical1, [logical2], …)

  Example

  =AND(B3>=50, C3>=50)→returnsFALSE

• OR

  Full guide →

  Returns TRUE when at least one condition is TRUE.

  OR(logical1, [logical2], …)

  Example

  =OR(B3<50, C3<50, D3<50)→returnsTRUE

• IFS

  Full guide →

  Tests conditions in order and returns the value for the first one that's TRUE. Cleaner than nesting several IFs, for example for grade bands.

  IFS(logical_test1, value_if_true1, …)

  Example

  =IFS(B4>=90, "A", B4>=80, "B", B4>=70, "C", TRUE, "D")→returnsA

Common mistakes

1. 1

   Quoting the wrong things

   Text results need quotes: =IF(B2>=50,Pass,Fail) gives #NAME? because Excel reads Pass as a name. Numbers don't: B2>="50" compares the score with the text "50" and gives the wrong answer.

2. 2

   Testing conditions in the wrong order

   IFS and nested IFs stop at the first TRUE condition. If B2>=50 comes before B2>=90, a score of 95 stops at the first test and never reaches the top band. Start with the strictest condition.

3. 3

   Leaving IFS without a fallback

   When none of its conditions is TRUE, IFS returns #N/A. End it with TRUE, "value" so every row gets an answer.