| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Length
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| dragging a formula | Excel Discussion (Misc queries) | |||
| Again-revealing the contents of formula | Excel Worksheet Functions | |||
| formula to standarize cell length | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Threaded Mode
