What I have are a series of Work Codes (shown Below). All work codes in the
10 range are paid at one rate all work codes in the 20 range at another. I
need write a formula which looks only at the first number of the work code
and if it is 1 return the value $18.50, if it is 2 then return the value
$21.36.

I know I can use an If statement to look at each number but this is just a
representative example. I actually have 6 different pay rates associated
with over 30 work codes.

10
11
12

20
21
22