Transcript L6 If Statements

If Statements
GCSE Requirements
You are required to be able to use
spreadsheet software for ‘the solution of
'what if'… problems’
A business problem
A manager has the
following employee
list in a spreadsheet:
Employee Name
Department
Jim baker
Sales
Jack Down
Marketing
Sam Craven
Marketing
Sam Bibby
Sales
Nick Powel
Marketing
Paul Vowell
Sales
Sam Link
Marketing
Pete Small
Sales
Jack Gillingham
Marketing
Paul McGregor
Sales
Lisa Drake
Marketing
Janet Jones
Sales
Gareth Hawes
Marketing
Chris Haines
Sales
Barbara Strawe
Sales
A business problem
He would like to add
a third column which
says who their
manager is:
Employee Name
Department
Jim baker
Sales
Jack Down
Marketing
Sam Craven
Marketing
Sam Bibby
Sales
Nick Powel
Marketing
Paul Vowell
Sales
Sam Link
Marketing
Pete Small
Sales
Jack Gillingham
Marketing
Paul McGregor
Sales
Lisa Drake
Marketing
Janet Jones
Sales
Gareth Hawes
Marketing
Chris Haines
Sales
Barbara Strawe
Sales
Manager
A Business Problem
He knows that if they work for Sales their
manager is James Dean and if they work
for Marketing their manager is Dale
Sutton
 Rather than type out the same thing in all
the columns he would like to use an if
statement

A Business Problem
The if statement in a spreadsheet helps
answer a ‘what if?’ type of question
 if they work for Sales their manager is
James Dean and if they work for
Marketing their manager is Dale Sutton

A Business Problem

The formula is built up in this way
If the department is sales then put
James Dean otherwise put Dale Sutton
OR
=if(department=‘sales’,’James Dean’,’Dale Sutton’)
A Business Problem

Now follow the on screen
demonstration………..