help with macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a macro that compares the number of hours an employee worked
to the list below to determine employee cost for Ind or Family.
If someone works 37 hrs their cost would be 45.73 or 101.40. Any help would
be great.

# of Hrs Individual Family
40 $37.71 $83.62
38 $41.72 $92.51
36 $45.73 $101.40
35 $47.73 $105.84
34 $49.73 $110.28
32 $53.74 $119.17
30 $57.75 $128.06
28 $61.76 $136.00
26 $65.77 $145.83
24 $69.78 $154.72
22 $73.78 $163.61
20 $77.79 $172.49
 
I would first invert the table so the least number of hours is at the top.

I would then insert the odd-valued hours like 21,23, etc.

At that point you can use VLOOKUP() to locate the data for any hour amoutn.
 
Back
Top