Multiple IF statement with CONCATENATE

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

Try this formula:

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

Originally Posted by dadm20

thank you.

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

=IF(AND(X2="100000000000000",E2="01"),"63"&B2&C2,"",IF(AND(X2="010000000000000",E3="02"),"63"&B3&C3,"",IF(AND(X2="001000000000000",E3="03"),"63"&B4&C4,"",IF(AND(X2="000100000000000",E3="04"),"63"&B5&C5,"",IF(AND(X2="000010000000000",E3="05"),"63"&B6&C6,"",IF(AND(X2="000001000000000",E3="06"),"63"&B7&C7,"",IF(AND(X2="000000100000000",E3="07"),"63"&B8&C8,"",IF(AND(X2="000000010000000",E3="08"),"63"&B9&C9,"",IF(AND(X2="000000001000000",E3="09"),"63"&B10&C10,""))

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

Try this instead....

=IF(FIND("1",X2)=INDIRECT("E"&FIND("1",X2)+1)+0,"63"&INDIRECT("B"&FIND("1",X2)+1)&INDIRECT("C"&FIND("1",X2)+1),"")