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