If Statements

1. If Statements

2. GCSE Requirements You are required to be able to use spreadsheet software for ‘the solution of 'what if'… problems’

3. A business problem A manager has the following employee list in a spreadsheet:

4. A business problem He would like to add a third column which says who their manager is:

5. 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

6. 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

7. 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’)

8. A Business Problem • Now follow the on screen demonstration………..