Spreadsheet: 168400d1342443403-help-on-if-statements-calculations-or-best-method-if-calculation
Sheet: Synergy 

 |  |  |  |  |  |  |  |  | Time of delivery |  |  |  |  |  |  |  | MD | Exec
 | Role | Grade | Family Code | Location | FTE | Business Unit | Category | £ [NAME] | Delivered | 2012-07-07 00:00:00 | 2012-08-07 00:00:00 | 2012-09-07 00:00:00 | 2012-10-07 00:00:00 | 2012-11-07 00:00:00 | 2012-12-07 00:00:00 | Total | H | H | G | F | EU | DU | C | B | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 607685 | 349366 | 150043 | 107285 | 73906 | 47522 | 33529 | 30596 | 25455
 | Assistant Manager | DU | FID100 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Analyst | C | SPC000 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Assistant Manager | DU | FID100 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Analyst | C | SPC000 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Analyst | C | SPC000 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Manager | EU | FIE101 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Assistant Manager | DU | FID100 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Assistant Manager | DU | FID100 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Assistant Manager | DU | FID100 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Analyst | C | SPC000 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Analyst | C | SPC000 | Vacancy | 1 | Executive | Vacancy Release | No | 1
 | Senior Manager | F | FIF 000 | London | 1 | Investment | Contractor Release | No | 1
 | Manager | EU | FIE101 | London | 1 | Investment | Contractor Release | Yes | 1 |  |  |  |  |  |  | IF(I16="Yes" and C13=EU, look for EU in row R2 to z2 and put the value 73,906*F16). IF I16 = No, leave blank
 | Manager | EU | FIE101 | London | 1 | Investment | Contractor Release | No | 1
 | Manager | EU | FIE101 | London | 1 | Investment | Redeployment/Exit | No | 1
 | Manager | EU | FIE101 | London | 1 | Investment | Redeployment/Exit | No | 1
 | Manager | EU | FIE101 | London | 1 | Investment | Contractor Release | No | 1
 | Manager | EU | FIE101 | London | 1 | Investment | Contractor Release | No | 1
 | Property Finance - Manager Facilities Management | EU | FIE101 | Halifax | 1 | Property/Sourcing | Contractor Release | Yes
 | Sourcing Finance - Assistant Manager | DU | FIE101 | Halifax/Bristol | 1 | Property/Sourcing | Contractor Release | Yes
 | Property Finance - Analyst | C | SPC000 | Halifax/Bristol | 1 | Property/Sourcing | Redeployment/Exit | Yes
 | Property Finance - Analyst | C | SPC000 | Halifax/Bristol | 0.9 | Property/Sourcing | Redeployment/Exit | Yes
 | Property Finance - Manager | EU | FIE101 | Halifax/Bristol | 1 | Property/Sourcing | Redeployment/Exit | Yes
 | Property Finance - Manager | EU | FIE101 | Halifax/Bristol | 0.6 | Property/Sourcing | Redeployment/Exit | Yes
 | Sourcing Finance - Manager | EU | FIE101 | Bristol | 0.4 | Property/Sourcing | Redeployment/Exit | Yes
 | Property Finance - Manager | EU | FIE101 | Halifax/Bristol | 0.6 | Property/Sourcing | Redeployment/Exit | Yes
 | Analyst - Mortgage Operations | C | SPC000 | Lovell Park, Leeds | 1 | Operations | Redeployment/Exit | Yes
 | [NAME] | C | SPC000 | Pendeford - Wolverhampton | 1 | Operations | Redeployment/Exit | Yes
 | Senior Manager | F | FIF001 | Citymark, Edinburgh | 1 | Operations | Redeployment/Exit | Yes
 | Assistant Manager - Project Evaluation | DU | FID100 | Brindley Place, Birmingham | 1 | Operations | Redeployment/Exit | Yes
 | Head of Finance - Project Evaluation | G | FIG000 | [NAME], London | 1 | Operations | Redeployment/Exit | Yes
 | Senior Manager - Global Payments | F | FIF001 | Citymark, Edinburgh | 0.6 | Operations | Redeployment/Exit | Yes
 | Senior Manager - Global Payments | F | FIF001 | Citymark, Edinburgh | 0.6 | Operations | Redeployment/Exit | Yes
 | Manager - Costing, CTC and Benefits Validation | EU | FIE101 | [NAME], London | 1 | Operations | Redeployment/Exit | Yes
 | Senior Manager - Simplification | F | FIF001 | [NAME], London | 1 | Operations | Redeployment/Exit | yes
 | Manager 1 - Simplification | EU | FIE101 | [NAME], London | 1 | Operations | Redeployment/Exit | yes
 | Manager [NAME] | EU | FIE101 | [NAME], London | 1 | Operations | Redeployment/Exit | yes
 | Head of Finance - Simplifiation | G | FIG000 | [NAME], London | -1 | Operations | Redeployment/Exit | yes
 | Assistant Manager - Global Payments | DU | FID100 | Citymark, Edinburgh | 1 | Operations | Contractor Exits | Yes
 | Assistant Manager - Global Payments | DU | FID100 | Citymark, Edinburgh | 1 | Operations | Contractor Exits | Yes
 | Assistant Manager - I&C | DU | FID100 | Cannons House, Bristol | 1 | Operations | Contractor Exits | Yes
 | Manager - I&C | EU | FIE101 | Cannons House, Bristol | 1 | Operations | Redeployment/Exit | Yes
 | Manager - FBP Central Functions | EU | FIE101 | [NAME], London | -1 | Operations | Redeployment/Exit | Yes
 | Senior Manager - Project Evaluation | F | FIF001 | [NAME], London | -1 | Operations | Redeployment/Exit | Yes
 | Assistant Manager - Project Evaluation | DU | FID100 | [NAME], London | 1 | Operations | Redeployment/Exit | Yes
 | Senior Manager - Customer Services | F | FIF001 | West Bank , Leeds | -1 | Operations | Redeployment/Exit | Yes
 | Assistant Manager1 - Customer Services | DU | FID100 | West Bank , Leeds | 1 | Operations | Redeployment/Exit | Yes
 | Manager S&OP (GSL) | EU | FIE101 | West Yorkshire | -1 | Operations | Redeployment/Exit | Yes
 | Senior Finance Partner | EL | FIE200 | West Yorkshire | 1 | Operations | Redeployment/Exit | Yes
 | Assistant Manager - Credit Operations | DU | FID100 | Hove | 1 | Operations | Redeployment/Exit | Yes
 | Assistant Manager - Wholesale Operations | DU | FID100 | Citymark, Edinburgh | 1 | Operations | Redeployment/Exit | Yes
 | Finance Assistant | C | SPC000 | Citymark, Edinburgh | 1 | Operations | Redeployment/Exit | Yes
 | Manager - CMU & Commercial Insight | EU | FIE101 | Brindley Place, Birmingham | 1 | Operations | Redeployment/Exit | Yes
 | Assistant Manager S&OP Business Services | DU | FID100 | Hove | 1 | Operations | Redeployment/Exit | Yes
 | Finance Manager, ADM | EU | FIE101 | London / Halifax / Edinburgh | 0.8 | IT | Redeployment/Exit | Yes
 | Finance Manager, F&C | EU | FIE101 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Assistant Finance Manager, CIO | DU | FID100 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Assistant Finance Manager, CIO | DU | FID100 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, IT Supply | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Edinburgh | 1 | IT | Contractor Exits | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Analyst, Transformation | DU | FID100 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, Transformation | EL | FIE200 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Analyst, Transformation | DU | FID100 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, F&C | EU | FIE101 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Assistant Finance Manager, F&C | DU | FID100 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Analyst, SD | DL | FID200 | London | 1 | IT | Redeployment/Exit | Yes
 | Finance Analyst, SD | DL | FID200 | London | 1 | IT | Redeployment/Exit | Yes
 | Finance Analyst, SD | DL | FID200 | London | 0.6 | IT | Redeployment/Exit | Yes
 | Finance Assistant, IT Supply | C | SPC000 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EL | FIE200 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EL | FIE200 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EL | FIE200 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Assistant, Transformation | C | SPC000 | London / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, SD | EL | FIE200 | London | 1 | IT | Redeployment/Exit | Yes
 | Senior Finance Manager, IT Supply | F | [NAME] | London | 1 | IT | Contractor Exits | Yes
 | Senior Finance Manager, F&C | F | [NAME] | London | 1 | IT | Contractor Exits | Yes
 | Finance Manager, CIO | EL | FIE200 | London | 1 | IT | Contractor Exits | Yes
 | Senior Finance Manager, SD | F | [NAME] | London | 1 | IT | Contractor Exits | Yes
 | Finance Assistant, CIO | EU | SPC000 | Edinburgh | 1 | IT | Contractor Exits | Yes
 | Senior Finance Manager, IT Supply | DU | SPC000 | London | 1 | IT | Contractor Exits | Yes
 | Finance Manager | EU | FIE200 | London / Halifax / Edinburgh | 0.9 | IT | Contractor Exits | Yes
 | Assistant Finance Manager | DL | FID100 | London / Halifax / Edinburgh | 1 | IT | Contractor Exits | Yes
 | Assistant Finance Manager | DU | FID100 | London / Halifax / Edinburgh | 0.4 | IT | Contractor Exits | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Manager, CIO | EU | FIE101 | London / Halifax / Edinburgh | 1 | IT | Redeployment/Exit | Yes
 | Finance Assistant, Transformation | C | SPC000 | London | 1 | IT | Redeployment/Exit | Yes
 | Senior Manager, GITO | F | [NAME] | London | -1 | IT | New Hires | Yes
 | Senior Manager, W&I and Products | F | [NAME] | London | -1 | IT | New Hires | Yes
 | Manager, KSOR finance | EU | FIE101 | London | -1 | IT | New Hires | Yes
 | Senior Manager, CIO | F | [NAME] | London | -1 | IT | New Hires | Yes
 | Assistant Manager EAD | DU | FID100 | London | -1 | IT | New Hires | Yes
 | Manager, IT Supply | EU | FIE101 | [NAME] | -1 | IT | New Hires | Yes
 | Finance Manager, Planning, IT Supply | EU | FIE101 | London | -1 | IT | New Hires | Yes
 | Manager [NAME] Finance | EU | FIE101 | London | -1 | IT | New Hires | Yes
 | Assistant Manager, ADM | DU | FID100 | London | -1 | IT | New Hires | Yes
 | Assistant Manager, GITO | DU | FID100 | Halifax | -1 | IT | New Hires | Yes
 | Manager ADM Finance | EU | FIE101 | Halifax | -1 | IT | New Hires | Yes
 | Manager ADM Finance | EU | FIE101 | London | -1 | IT | New Hires | Yes
 | Totals