IF specific text, then CONCATENATE

[Lizabeta]

This formula keeps giving me an error and I can't tell if its my logical test or parentheses (or something else) that is causing it...

IF J12 has the text "IEP" in it, I want it to concatenate the first part...
If J12 has anything else except IEP in it, I want it to concatenate the second part:



=IF(J12="IEP"), (CONCATENATE("PPS"," ",TEXT(C62,"mm-dd-yyyy")," ", E62," ",D62)), (CONCATENATE("SP"," ",TEXT(C62,"mm-dd-yyyy")," ", E62," ",D62))


It should be an easy one, but my brain is stuck in Monday

 

[dk]

Hi

The issue is your first closing parenthesis. I think this should fix it:

=IF(J12="IEP",CONCATENATE("PPS"," ",TEXT(C62,"mm-dd-yyyy")," ", E62," ",D62), CONCATENATE("SP"," ",TEXT(C62,"mm-dd-yyyy")," ", E62," ",D62))

HTH
DK

 

[crook_101]

Hi,

Untested but try:

=IF(J12="IEP",CONCATENATE("PPS"," ",TEXT(C62,"mm-dd-yyyy")," ", E62," ",D62),CONCATENATE("SP"," ",TEXT(C62,"mm-dd-yyyy")," ", E62," ",D62))

Cheers,
Ian

 

[Lizabeta]

Thank you! It does work! I fiddled with those parenetheses for 40 minutes before I gave up!

 

[crook_101]

Hi,

Top tip..... when you are having problems with a formula like this, click on the cell where the formula is then click on the formula bar so your cursor is at the start of the "=" sign. Move cursor with right arrow and this will "step" through the formula and you may see where for example, the parenethesis are in the wrong place as the formula sections are "displayed" in bold font below......

Hard to explain but give it a try

HTH
Ian

 

[Scott Huish]

This should do the same thing:

=IF(J12="IEP","PPS","SP")&TEXT(C62," mm-dd-yyyy ")&E62&" "&D62