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))))))))))))))))))))))))