J Juan Sanchez Jul 14, 2004 #2 Excel's limit for nesting is 7... i.e =IF(A1<>0,A1,IF(B1<>0,B1,IF(C1<>0,C1,...IF (G1<>0,G1,H1))))))) Cheers Juan
Excel's limit for nesting is 7... i.e =IF(A1<>0,A1,IF(B1<>0,B1,IF(C1<>0,C1,...IF (G1<>0,G1,H1))))))) Cheers Juan