I have a database with over 1,000 rows and 13 columns. One of the column
headings has a listing of about 23 different services. They want to add a
column basically assigning a number to each service....I know I can use the
IF function but apparently only for up to 8 arguments. Does anyone know if
there's a way to add more?? Is there a better formula for this?? Or can I
maybe lump three services???

A quick example of what I'm talking about

Services
NEB
CTH
IV
IV ABT
NEB

Say that's the list. I want to assign NEB's as a 1, IV and IV ABT as a 4.
I know I can use =IF(CELL="NEB",1,(IF(CELL="IV",4,(IF(CELL="IV ABT",4,0)))))
But after a certain amount it tells me there's an error. I will take any
help.