Nesting Problem

**ratu4110** · 07-03-2012, 11:05 AM

Hello,

I am here attaching the program I wrote in my excel sheet but it gave me error message for too much nesting. But I need urgent solution. Would you please help me in this context.

Thanks.

=+IF(C26=15,2,IF(C26=16,3,IF(C26=18,4,IF(C26=20,5,IF(C26=22,6,IF(C26="22x63%",7,IF(C26="2214x100x80%w",8,IF(C26="2412x95x60w",9,IF(C26="2412x95x67%w",10,IF(C26="2412x95x70%w",11,IF(C26="2412x95x85%w",12,IF(C26="2412x95x100%w",13,IF(C26="2412x100x70%w",14,IF(C26="2412x100x80%w",15,IF(C26="2412x100x100%w",16,IF(C26="2412x100x85%w",17,IF(C26="2700x95x50%w",18,IF(C26="2700x95x85%w",19,IF(C26="2700x100x50%w",20,IF(C26="2700x95x100%w",21,IF(C26="2700x100x85%w",22,IF(C26="2700x100x70%w",23,IF(C26="3000x95x85%w",24,IF(C26="3000x95x100%w",25))))))))))))))))))))))))

**Spencer101** · 07-03-2012, 11:12 AM

Perhaps putting the possible values for C26 and the values you want to show depending on the value in C26 in a table and use a lookup would be a better approach?

**ratu4110** · 07-03-2012, 04:33 PM

Actually I tried with VLOOKUP before but it changes other parameters, it does not work for me. SORRY!!

**Spencer101** · 07-03-2012, 04:41 PM

Perhaps an example workbook would be useful in order to help you out with this...

**Haseeb Avarakkan** · 07-03-2012, 08:49 PM

Hello ratu,

If your file is on xlsx version this should work, excel 2003 has only 7 nested levels. I think you are using xcel 2010 & file may be in xls format (97-2003 format)

Convert or save As file as Excel Workbook' hen use the formula.

You could simplify formula by MATCH. Enter all possible values like 15, 16, 18, 20, 22, 22x63%, 2214x100x80%w etc ... in a range ie H2:H25, then use

=IF(COUNTIF(H2:H25,C26),MATCH(C26,H2:H25,0)+1,"N/A")