T
trixma
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+K17
+ 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.
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+K17
+ 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.