| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many functions to nest?
I have 2 different products with 7 options each and I was trying to put them
into 6 categories. The products are "TOP HINGE" and "OFFSET TOP HINGE" and they each have an option of "O EXT", "12 EXT", "18 EXT", "24 EXT", "30 EXT", "36 EXT", "48 EXT". Now I am trying to give "TOP HINGE-0 EXT" a value of 1, "TOP HINGE-12 EXT" a value of 2, and "TOP HINGE-18 EXT" on up a value of 3 and "OFFSET TOP HINGE" option follows that same pattern. I used =IF(M52="TOP HINGE-0 EXT",1,IF(M52="TOP HINGE-12 EXT",2,IF(AND(M52="TOP HINGE-18 EXT",M52="TOP HINGE-24 EXT",M52="TOP HINGE-30 EXT",M52="TOP HINGE-36 EXT",M52=TOP HINGE-48 EXT"),3,IF(M52="OFFSET TOP HINGE-0 EXT",4,IF(M52="OFFSET TOP HINGE-12 EXT",5,IF(AND(M52="OFFSET TOP HINGE-18 EXT",M52="OFFSET TOP HINGE-24 EXT",M52="OFFSET TOP HINGE-30 EXT",M52="OFFSET TOP HINGE-36 EXT",M52=OFFSET TOP HINGE-48 EXT"),6,0)))))) But it seems to be too many functions or I missed something. Is there any help for this? I definitely appreciate any help. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to nest more than 7 functions | Excel Discussion (Misc queries) | |||
| help with functions to nest | Excel Worksheet Functions | |||
| How can I nest ISTEXT and IF functions? | Excel Worksheet Functions | |||
| how do I nest functions | Excel Worksheet Functions | |||
| How do I nest these 3 IF functions? | Excel Worksheet Functions | |||
Threaded Mode
