if statements. gcse requirements you are required to be able to use spreadsheet software for ‘the...
TRANSCRIPT
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 Manager
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 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………..