Hello!

I need help assigning a specific value to a number range. Our life insurance premiums are calucated by the employee's age. A specific rate used in the calculation is assigned according to age. Below are the rates used per age range:

<30=0.21
30-34=0.22
35-39=0.26
40-44=0.37
45-49=0.54
50-54=0.81
55-59=1.36
60-64=1.50
65-69=2.51
70-74=4.40
75+=16.50

The employee's age is listed in column D, I would like the rate to automatically populate in column P.

Thanks in advance for all your help!!!