List your years and pay rates and then try something like:

=VLOOKUP(MIN(DATEDIF(A1,TODAY(),"y"),13),F1:G14,2)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"AnnC" wrote in message
...
Hi Kassie,

I did not give enough info. I have about 200 union people on the payroll.
The union contract specifies the wage based on number of years worked.
for
example for years 0-1 the starting wage is $12.00, after 1 year it is
12.50
per hour, after 3 years 13.00, etc.etc. up to and capped at after 13
years.

In one column I have employees start date, in the next column I'm
calculating the number of years worked. The next column would be the
current
rate based on the above criteria. It would be neat if I could set up the
little table that would automatically enter the wage rate.

Thanks for your help
Ann

"Kassie" wrote:

Hi Ann

So what is your question? Looks like plain data input to me! No
calculations or anything like that required here. I would however enter
the
wages in columns, rather than rows. In that way you use one row per
employee, so headings would be:

Name | Year1 | Year 2| and so on

Maybe an additional column just after name,to calculate the number of
years
already worked?

--
ve_2nd_at. Randburg, Gauteng, South Africa


"AnnC" wrote:

set up table that would feed column "current wage". Table would
consist of
years worked and associated wage. example:

name years worked current wage

TABLE
Years Wage
0 10.00
1 12.00
2 12.50
etc for about 20 years