Multiple IF statement with CONCATENATE

[dadm20]

I cant use this formula. excel gives an error that my statement is too long, what are my other options?

=IF(AND(F2="100000000000000",E2="02"),CONCATENATE("63",B2,C2),"",IF(AND(F2="010000000000000",E3="06"),CONCATENATE("63",B3,C3),""))

this is just 2 statements and i am having an error, i thought if i could make 15 statements? I need to CONCATENATE 7 cells (the example above is just 3 cells) based on certain condition. How can i do it? Anyone please? Thanks in advance.

Like this:
>B2=11111111
>B3=22222222
>C2=3
>C3=4
>F2 is from 000000000000000 ... 000010000000000 to 000000000000001 ("1" is moving from left to right)
>IF F2=”100000000000000” -> output is “63111111113”
>IF F2=”010000000000000” -> output is “63222222224”
> I should do this 15 times

[NBVC]

Try this formula:

Please Login or Register  to view this content.

[dadm20]

thank you.

but what if i have 9 "IF" statements? like:

Please Login or Register  to view this content.

can i make it up to 15 "IF" statements?

[arthurbr]

You can't nets more than 7 IF's, but you can name formulas, which will allow you to beat the limitation
http://cpearson.com/excel/nested.htm

[NBVC]

thank you.

but what if i have 9 "IF" statements? like:

Please Login or Register  to view this content.

can i make it up to 15 "IF" statements?

Try this instead....

Please Login or Register  to view this content.

[dadm20]

Thanks a lot guys, i really appreciate all your effort.