Linking two IF statements together

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.
 
D

duane

try this - note default to cell B1 if none of first six conditions ar
met. Seveneth condition now in cell B1

Cell A1 =IF(B17>=0,B2+(Input!B2-B17)/Input!B2,IF(B17+C17>=0,C
-1+((Input!B2-B17)-C17)/Input!B2,IF(B17+C17+D17>=0,D
-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,
B1))))))

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

JE McGimpsey

If you really can't alter the cells in any way (and that's too bad,
because they could be simplified immensely), the only way I can think of
to "link" them would be to do something like:

C1: =IF(A1,A1,B1)

If that's not what you mean by "link", post back with an example.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top