software

I am aware that the max # of (IF) arguments is 8. the following formula use
all 8 but when i try and add another function to it i get an error message.

=IF($O$7=quot;1552.52 / 1530.33quot;,CONCATENATE(tx52type,quot;
quot;,tx52a1),IF($O$7=quot;1549.32 / 1536.61quot;,CONCATENATE(tx49type,quot;
quot;,tx49a1),IF($O$7=quot;1555.75 / 1533.47quot;,CONCATENATE(tx55type,quot;
quot;,tx55a1),IF($O$7=quot;1558.98 / 1538.19quot;,CONCATENATE(tx58type,quot;
quot;,tx58a1),IF($O$7=quot;1550.92 / 1528.77quot;,CONCATENATE(tx50type,quot;
quot;,tx50a1),IF($O$7=quot;1554.13 / 1531.90quot;,CONCATENATE(tx54type,quot;
quot;,tx54a1),IF($O$7=quot;1558.17 / 1538.98quot;,CONCATENATE(tx58.17type,quot;
quot;,tx58aa1),IF($O$7=quot;1547.72 / 1539.77quot;,tx47type,W7))))))))

I would like to add one more concatenate statment to the last if statement
but it will not allow me to. WHY?

here is what i need it to say when i am done.

=IF($O$7=quot;1552.52 / 1530.33quot;,CONCATENATE(tx52type,quot;
quot;,tx52a1),IF($O$7=quot;1549.32 / 1536.61quot;,CONCATENATE(tx49type,quot;
quot;,tx49a1),IF($O$7=quot;1555.75 / 1533.47quot;,CONCATENATE(tx55type,quot;
quot;,tx55a1),IF($O$7=quot;1558.98 / 1538.19quot;,CONCATENATE(tx58type,quot;
quot;,tx58a1),IF($O$7=quot;1550.92 / 1528.77quot;,CONCATENATE(tx50type,quot;
quot;,tx50a1),IF($O$7=quot;1554.13 / 1531.90quot;,CONCATENATE(tx54type,quot;
quot;,tx54a1),IF($O$7=quot;1558.17 / 1538.98quot;,CONCATENATE(tx58.17type,quot;
quot;,tx58aa1),IF($O$7=quot;1547.72 / 1539.77quot;,CONCATENATE(tx58.17type,quot;
quot;,tx58aa1),W7))))))))

Sorry for the short cell id's but i had to do this so i would not reach
excel's max char lenght.
David

I'm not an expert but I'm guessing that you have reached the limit for that
formula.

From what I can tell, you're using the 3rd and 4th character from the left
to merge named cells, except maybe 1 (tx58.17type) which doesn't seem to
follow the same format. If so then maybe this would help:

=IF(MID($O$7,3,5)=quot;58.17quot;,tx58.17amp;quot;
quot;amp;tx58aa1,IF(ISERROR(INDIRECT(quot;txquot;amp;MID($O$7,3,2)amp;quot; typequot;)amp;quot;
quot;amp;INDIRECT(quot;txquot;amp;MID($O$7,3,2)amp;quot;a1quot;)),W7,INDIRECT(quot; txquot;amp;MID($O$7,3,2)amp;quot;typequot;)amp;quot;
quot;amp;INDIRECT(quot;txquot;amp;MID($O$7,3,2)amp;quot;a1quot;)))

HTH
JG

quot;Dromanquot; wrote:

gt; I am aware that the max # of (IF) arguments is 8. the following formula use
gt; all 8 but when i try and add another function to it i get an error message.
gt;
gt; =IF($O$7=quot;1552.52 / 1530.33quot;,CONCATENATE(tx52type,quot;
gt; quot;,tx52a1),IF($O$7=quot;1549.32 / 1536.61quot;,CONCATENATE(tx49type,quot;
gt; quot;,tx49a1),IF($O$7=quot;1555.75 / 1533.47quot;,CONCATENATE(tx55type,quot;
gt; quot;,tx55a1),IF($O$7=quot;1558.98 / 1538.19quot;,CONCATENATE(tx58type,quot;
gt; quot;,tx58a1),IF($O$7=quot;1550.92 / 1528.77quot;,CONCATENATE(tx50type,quot;
gt; quot;,tx50a1),IF($O$7=quot;1554.13 / 1531.90quot;,CONCATENATE(tx54type,quot;
gt; quot;,tx54a1),IF($O$7=quot;1558.17 / 1538.98quot;,CONCATENATE(tx58.17type,quot;
gt; quot;,tx58aa1),IF($O$7=quot;1547.72 / 1539.77quot;,tx47type,W7))))))))
gt;
gt; I would like to add one more concatenate statment to the last if statement
gt; but it will not allow me to. WHY?
gt;
gt; here is what i need it to say when i am done.
gt;
gt; =IF($O$7=quot;1552.52 / 1530.33quot;,CONCATENATE(tx52type,quot;
gt; quot;,tx52a1),IF($O$7=quot;1549.32 / 1536.61quot;,CONCATENATE(tx49type,quot;
gt; quot;,tx49a1),IF($O$7=quot;1555.75 / 1533.47quot;,CONCATENATE(tx55type,quot;
gt; quot;,tx55a1),IF($O$7=quot;1558.98 / 1538.19quot;,CONCATENATE(tx58type,quot;
gt; quot;,tx58a1),IF($O$7=quot;1550.92 / 1528.77quot;,CONCATENATE(tx50type,quot;
gt; quot;,tx50a1),IF($O$7=quot;1554.13 / 1531.90quot;,CONCATENATE(tx54type,quot;
gt; quot;,tx54a1),IF($O$7=quot;1558.17 / 1538.98quot;,CONCATENATE(tx58.17type,quot;
gt; quot;,tx58aa1),IF($O$7=quot;1547.72 / 1539.77quot;,CONCATENATE(tx58.17type,quot;
gt; quot;,tx58aa1),W7))))))))
gt;
gt; Sorry for the short cell id's but i had to do this so i would not reach
gt; excel's max char lenght.
gt; David