Exercise 6

Create a spreadsheet to allocate points won in a football match. A team wins 3 points if they win a game, 1 point if they draw and 0 points if they lose. Construct a spreadsheet that will calculate the points won in the following games:

NB. The conditional formulae only accounts for two possible outcomes. Since the above exercise requires three posible outcomes we need to insert a new condition into the formula:

=IF(Condition,Outcome if True,IF(Condition,Outcome if True,Outcome if False))

Alter the scores to Swansea City 1 Cardiff City 1 and Chester 2 Torquay 1.

Contents: Spreadsheets

Skill Check: Spreadsheets