### Excel 2003: IF...Then, Nested IFs, IF OR, IF AND

The ticks indicate the suitability of resources for each Key Stage.

#### KS5

IF...Then Workbook

Explains step-by-step how to set up an IF...Then function.

Students are then given 4 further tasks to practice this skill

##### The Lakeside Theatre Company

This task provides students with a number of opportunities to practice simple and complex IF statements

(subscription only)

##### Count IFULA

This spreadsheet exercise provides students with an opportunity to practise:

• IF formula
• COUNTIF formula
• COUNTA formula
• COUNT formula
• RANK formula

Contributed by Jon Bridgeman of Finham Park School

### Nested IFs, IF(OR), IF(AND)

The ticks indicate the suitability of resources for each Key Stage.

#### KS5

Nested IF, IF (Or), IF (AND) Workbook

This workbook goes through how to set up Nested IFs, IF (OR) and IF (AND) Functions.

There are 9 practice tasks to ensure that students become confident with these skills

Cars, nested IF

##### Create a Multiple Choice Quiz

During this task, students will learn how to write nested if functions in order to create a multiple choice quiz which provides feedback based on the input answer.

The task sheet, quiz template and video tutorial are provided.

This task is probably better suited to higher ability students

(subscription only)