Hi All,
Cant seem to expand more on the statements using this IF statement so i've had to end it on "Check File Name"
Any help would be most appreciated in an alternative way of writing the statement
I=IF(OR(N2="Rimes"),CONCATENATE(C2,D2,".CSV"),IF((N2="FTSE"),CONCATENATE(C2,E2,".CSV"),IF((N2="Barclays"),CONCATENATE(C2,F2,".CSV"),IF((N2="Bloomberg"),CONCATENATE(C2,G2,".CSV"),IF((N2="Iboxx"),CONCATENATE(C2,H2,".CSV"),IF((N2="ICEBoAML"),CONCATENATE(C2,I2,".CSV"),IF((N2="Markit"),CONCATENATE(C2,J2,".CSV"),"Check File Name")))))))
Many thanks
Martin
Cant seem to expand more on the statements using this IF statement so i've had to end it on "Check File Name"
Any help would be most appreciated in an alternative way of writing the statement
I=IF(OR(N2="Rimes"),CONCATENATE(C2,D2,".CSV"),IF((N2="FTSE"),CONCATENATE(C2,E2,".CSV"),IF((N2="Barclays"),CONCATENATE(C2,F2,".CSV"),IF((N2="Bloomberg"),CONCATENATE(C2,G2,".CSV"),IF((N2="Iboxx"),CONCATENATE(C2,H2,".CSV"),IF((N2="ICEBoAML"),CONCATENATE(C2,I2,".CSV"),IF((N2="Markit"),CONCATENATE(C2,J2,".CSV"),"Check File Name")))))))
Many thanks
Martin