Hi there, I am currently doing some work where by I need to forecast projected salaries from 2011-15 (assuming nothing bad happens on 21/12/12 lol!)

We have 3 departments, each with 4 PayBands so in total there are 12 different paybands.

The pay goes up after so many years service, so less than 4 years is Band 1, 4-7 years Band 2, 8-12 years Band 3 and 13+ Band 4.

I can not seem to get my head around this (I have done this from scratch so I have not had anything to work from.

This is what I am trying to say

IF(AND(C2="Production", EMPLOYEES!M2="G1", IF(DATEDIF((D2,"31/12/2011","y")<=3), RATES!$D$10,
IF(AND(C2="Production",EMPLOYEES!M2="G2", IF(DATEDIF((D2,"31/12/2011","y")<=7), RATES!$D$11,
IF(AND(C2="Production", EMPLOYEES!M2="G3", IF(DATEDIF((D2,"31/12/2011,"y")<=12), RATES!$D$12,
IF(AND(C2="Production", EMPLOYEES!M2="G4", IF(DATEDIF((D2,"31/12/2011","y")>13), RATES!$D$13,

IF(AND(C2="Design", EMPLOYEES!M2="G1", IF(DATEDIF((D2,"31/12/2011","y")<=3), RATES!$D$6,
IF(AND(C2="Design",EMPLOYEES!M2="G2", IF(DATEDIF((D2,"31/12/2011","y")<=7), RATES!$D$7,
IF(AND(C2="Design", EMPLOYEES!M2="G3", IF(DATEDIF((D2,"31/12/2011,"y")<=12), RATES!$D$8,
IF(AND(C2="Design", EMPLOYEES!M2="G4", IF(DATEDIF((D2,"31/12/2011","y")>13), RATES!$D$9,

IF(AND(C2="Admin", EMPLOYEES!M2="G1", IF(DATEDIF((D2,"31/12/2011","y")<=3), RATES!$D$2,
IF(AND(C2="Admin",EMPLOYEES!M2="G2", IF(DATEDIF((D2,"31/12/2011","y")<=7), RATES!$D$3,
IF(AND(C2="Admin", EMPLOYEES!M2="G3", IF(DATEDIF((D2,"31/12/2011,"y")<=12), RATES!$D$4,
IF(AND(C2="Admin", EMPLOYEES!M2="G4", IF(DATEDIF((D2,"31/12/2011","y")>13), RATES!$D$5,
IF(EMPLOYEES!M2="G4", IF(DATEDIF((D2,"31/12/2001","y")=20), RATES!$D$5*1.008, "ERROR"

I have a working formula for working out what grades staff will be this year, next year any advice!!? Really really appreciated

Thanks

Chris