IF: Argument problem

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="1552.52 / 1530.33",CONCATENATE(tx52type,"
",tx52a1),IF($O$7="1549.32 / 1536.61",CONCATENATE(tx49type,"
",tx49a1),IF($O$7="1555.75 / 1533.47",CONCATENATE(tx55type,"
",tx55a1),IF($O$7="1558.98 / 1538.19",CONCATENATE(tx58type,"
",tx58a1),IF($O$7="1550.92 / 1528.77",CONCATENATE(tx50type,"
",tx50a1),IF($O$7="1554.13 / 1531.90",CONCATENATE(tx54type,"
",tx54a1),IF($O$7="1558.17 / 1538.98",CONCATENATE(tx58.17type,"
",tx58aa1),IF($O$7="1547.72 / 1539.77",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="1552.52 / 1530.33",CONCATENATE(tx52type,"
",tx52a1),IF($O$7="1549.32 / 1536.61",CONCATENATE(tx49type,"
",tx49a1),IF($O$7="1555.75 / 1533.47",CONCATENATE(tx55type,"
",tx55a1),IF($O$7="1558.98 / 1538.19",CONCATENATE(tx58type,"
",tx58a1),IF($O$7="1550.92 / 1528.77",CONCATENATE(tx50type,"
",tx50a1),IF($O$7="1554.13 / 1531.90",CONCATENATE(tx54type,"
",tx54a1),IF($O$7="1558.17 / 1538.98",CONCATENATE(tx58.17type,"
",tx58aa1),IF($O$7="1547.72 / 1539.77",CONCATENATE(tx58.17type,"
",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)="58.17",tx58.17&"
"&tx58aa1,IF(ISERROR(INDIRECT("tx"&MID($O$7,3,2)&"type")&"
"&INDIRECT("tx"&MID($O$7,3,2)&"a1")),W7,INDIRECT("tx"&MID($O$7,3,2)&"type")&"
"&INDIRECT("tx"&MID($O$7,3,2)&"a1")))

HTH
JG

"Droman" wrote:

> 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="1552.52 / 1530.33",CONCATENATE(tx52type,"
> ",tx52a1),IF($O$7="1549.32 / 1536.61",CONCATENATE(tx49type,"
> ",tx49a1),IF($O$7="1555.75 / 1533.47",CONCATENATE(tx55type,"
> ",tx55a1),IF($O$7="1558.98 / 1538.19",CONCATENATE(tx58type,"
> ",tx58a1),IF($O$7="1550.92 / 1528.77",CONCATENATE(tx50type,"
> ",tx50a1),IF($O$7="1554.13 / 1531.90",CONCATENATE(tx54type,"
> ",tx54a1),IF($O$7="1558.17 / 1538.98",CONCATENATE(tx58.17type,"
> ",tx58aa1),IF($O$7="1547.72 / 1539.77",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="1552.52 / 1530.33",CONCATENATE(tx52type,"
> ",tx52a1),IF($O$7="1549.32 / 1536.61",CONCATENATE(tx49type,"
> ",tx49a1),IF($O$7="1555.75 / 1533.47",CONCATENATE(tx55type,"
> ",tx55a1),IF($O$7="1558.98 / 1538.19",CONCATENATE(tx58type,"
> ",tx58a1),IF($O$7="1550.92 / 1528.77",CONCATENATE(tx50type,"
> ",tx50a1),IF($O$7="1554.13 / 1531.90",CONCATENATE(tx54type,"
> ",tx54a1),IF($O$7="1558.17 / 1538.98",CONCATENATE(tx58.17type,"
> ",tx58aa1),IF($O$7="1547.72 / 1539.77",CONCATENATE(tx58.17type,"
> ",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