Long IF statement--gives formula parse error

I am trying to evaluate text in a cell. I have 132 combinations that I am evaluating for. Each combination represents a different number. When it finds the matching combination, I want the number that corresponds to be put in the cell. I typed in this long IF statement and it gives me a formula parse error. What am I doing wrong?

One additional thing to add...the cell I am evaluating...I have used the CONCATENATE function to create the text I am evaluating.

=if(e2="VRWHJ",3.2,if(e2="VRSHE",2.0,if(e2="VRSSE",2.3,if(e2="VRCONK",3.2,if(e2="VRBIS",2.3,if(e2="VRCJH",.3,if(e2="VRGRC",1.4,if(e2="VRPS",1.5,if(e2="VRCO",2.7,if(e2="VRATC",.2,if(e2="VRBG",2.7,if(e2="WHJVR",3.2,if(e2="WHJSHE",1.4,if(e2="WHJSSE",4.4,if(e2="WHJCONK",.1,if(e2="WHJBIS",4.4,if(e2="WHJCJH",3.0,if(e2="WHJGRC",4.6,if(e2="WHJPS",2.6,if(e2="WHJCO",3.8,if(e2="WHJATC",3.5,if(e2="WHJBG",3.8,if(e2="SHEVR",2.0,if(e2="SHEWHJ",1.4,if(e2="SHESSE",3.2,if(e2="SHECONK",1.4,if(e2="SHEBIS",3.2,if(e2="SHECJH",1.7,if(e2="SHEGRC",3.3,if(e2="SHEPS",1.3,if(e2="SHECO",2.7,if(e2="SHEATC",2.2,if(e2="SHEBG",2.7,if(e2="SSEVR",2.3,if(e2="SSEWHJ",4.4,if(e2="SSESHE",3.2,if(e2="SSECONK",3.8,if(e2="SSEBIS",.1,if(e2="SSECJH",2.6,if(e2="SSEGRC",3.4,if(e2="SSEPS",2.7,if(e2="SSECO",.6,if(e2="SSEATC",2.5,if(e2="SSEBG",.6,if(e2="CONKVR",3.2,if(e2="CONKWHJ",.1,if(e2="CONKSHE",1.4,if(e2="CONKSSE",3.8,if(e2="CONKBIS",4.4,if(e2="CONKCJH",3.0,if(e2="CONKGRC",4.6,if(e2="CONKPS",2.6,if(e2="CONKCO",3.8,if(e2="CONKATC",3.4,if(e2="CONKBG",3.8,if(e2="BISVR",2.3,if(e2="BISWHJ",4.4,if(e2="BISSHE",3.2,if(e2="BISSSE",.1,if(e2="BISCONK",4.4,if(e2="BISCJH",2.6,if(e2="BISGRC",3.4,if(e2="BISPS",2.7,if(e2="BISCO",.6,if(e2="BISATC",2.5,if(e2="BISBG",.6,if(e2="CJHVR",.3,if(e2="CJHWHJ",3.0,if(e2="CJHSHE",1.7,if(e2="CJHSSE",2.6,if(e2="CJHCONK",3.0,if(e2="CJHBIS",4.4,if(e2="CJHGRC",1.6,if(e2="CJHPS",1.3,if(e2="CJHCO",3.0,if(e2="CJHATC",.2,if(e2="CJHBG",3.0,if(e2="GRCVR",1.4,if(e2="GRCWHJ",4.6,if(e2="GRCSHE",3.3,if(e2="GRCSSE",3.4,if(e2="GRCCONK",4.6,if(e2="GRCBIS",3.4,if(e2="GRCCJH",1.6,if(e2="GRCPS",2.9,if(e2="GRCCO",3.9,if(e2="GRCATC",1.6,if(e2="GRCBG",3.9,if(e2="PSVR",1.5,if(e2="PSWHJ",2.6,if(e2="PSSHE",1.3,if(e2="PSSSE",2.7,if(e2="PSCONK",2.6,if(e2="PSBIS",2.7,if(e2="PSCJH",1.3,if(e2="PSGRC",2.9,if(e2="PSCO",3.0,if(e2="PSATC",1.4,if(e2="PSBG",3.0,if(e2="COVR",2.7,if(e2="COWHJ",3.8,if(e2="COSHE",2.7,if(e2="COSSE",.6,if(e2="COCONK",3.8,if(e2="COBIS",.6,if(e2="COCJH",3.0,if(e2="COGRC",3.9,if(e2="COPS",3.0,if(e2="COATC",2.9,if(e2="COBG",.1,if(e2="ATCVR",.2,if(e2="ATCWHJ",3.5,if(e2="ATCSHE",2.2,if(e2="ATCSSE",2.5,if(e2="ATCCONK"3.4,if(e2="ATCBIS",2.5,if(e2="ATCCJH",.2,if(e2="ATCGRC",1.6,if(e2="ATCPS",1.4,if(e2="ATCCO",2.7,if(e2="ATCBG",2.7,if(e2="BGVR",2.7,if(e2="BGWHJ",3.8,if(e2="BGSHE",2.7,if(e2="BGSSE",.6,if(e2="BGCONK",3.8,if(e2="BGBIS",.6,if(e2="BGCJH",3.0,if(e2="BGGRC",3.9,if(e2="BGPS",3.0,if(e2="BGCO",.1,if(e2="BGATC"2.7))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Thanks in advance for your answer.

If you are using 2003 you can only have, I think, 7 levels of nesting.

Use a lookup table with VLOOKUP.

Regards, TMS

1) Add a new sheet, let's name the sheet Lookup
2) ON the new Lookup sheet create a two column Table. Column A is the string to find, column B is the result

Please Login or Register  to view this content.

3) Now, back on your original sheet, your formula can be replaced with a simple VLOOKUP():

=VLOOKUP(E2, Lookup!$A:$B, 2, 0)

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

Thanks for the rep, although JB did the work and made the concept into a reality for you.

Regards, TMS