See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Patrick C. Simonds" wrote in message
...
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