Hi all,

I tried the following formula:
=IF(L6=1,"ABC",IF(L6=2,"DEF",IF(L6=3,"GHI",IF(L6=4 ,"JKL",IF(L6=5,"MNO",IF(L6=6,"PQR",IF(L6=7,"STU",I F(L6=8,"VWX","XYZ"))))))))

As in this formula, i can test 9 situations only. but i want to set more
conditions on that cell only.

but excel is not accepting more values than 9. how can i do it?

please suggest.

Regards
Mukesh