In excel you can only have 7 nested if statements in one cell, i need a
10 nested if statement and my if statements are below

Cell A1 =IF(B17=0,B2+(Input!B2-B17)/Input!B2,IF(B17+C17=0,C2
-1+((Input!B2-B17)-C17)/Input!B2,IF(B17+C17+D17=0,D2
-1+(((Input!B2-B17)-C17)-D17)/Input!B2,IF(B17+C17+D17+E17=0,E2
-1+((((Input!B2-B17)-C17)-D17)-E17)/Input!B2,IF(B17+C17+D17+E17+F17=0,
F2-1+(((((Input!B2-B17)-C17)-D17)-E17)-F17)/Input!B2,IF(B17+C17+D17+E17+F17+
G17=0,G2-1+((((((Input!B2-B17)-C17)-D17)-E17)-F17)-G17)/Input!B2,
IF(B17+C17+D17+E17+F17+G17+H17=0,
H2-1+(((((((Input!B2-B17)-C17)-D17)-E17)-F17)-G17-H17)/Input!B2,
))))))))

Cell B1 =IF(B17+C17+D17+E17+F17+G17+H17+I17=0,I2 - 1
+((((((((Input!B2-B17)-C17)-D17)-E17)-F17)-G17)-H17)-I17)/Input!B2,IF(B17+C17+D17+E17+F17+G17+H17+I17+J17=0 ,
J2 - 1
+(((((((((Input!B2-B17)-C17)-D17)-E17)-F17)-G17)-H17)-I17)-J17)/Input!B2,IF(B17+C17+D17+E17+F17+G17+H17+I17+J17
+ K17=0, K2 -1
+((((((((((Input!B2-B17)-C17)-D17)-E17)-F17)-G17)-H17)-I17)-J17)-K17)/Input!B2,IF(B17+C17+D17+E17+F17+G17+H17+I17+J17+K1 7
+ L17=0, L2 -1 +
(((((((((((Input!B2-B17)-C17)-D17)-E17)-F17)-G17)-H17)-I17)-J17)-K17)-L17)/Input!B2))))

I tried using goto to link the 2 if statements together with no luck. I
have to use the if statements like they are and i cannot alter them in
any way or use hidden fields. Does anyone know how I could link these
to statements together?

Thanks Trixma.


--
trixma
------------------------------------------------------------------------
trixma's Profile: http://www.excelforum.com/member.php...o&userid=25702
View this thread: http://www.excelforum.com/showthread...hreadid=471643