Excel IF and Concatenate problem

[mrsushi]

Trying to formulate the following condition with an IF and Concatenate

I have data in column AD

AB is my formula =IF(AC5="ISSUE PRICE",CONCATENATE(AD),CONCATENATE("BLOOMBERG"," ",AD5))

What I am trying to do is concatenate the narrative

if "Issue Price" is in the Column AD, then produce narrative "ISSUE PRICE".
If "Issue Price" is NOT in the Column AD, then create the narrative "BLOOMBERG" + whatever is present in cell ie MSG1, EQ etc so it end up being BLOOMBERG MSG1, BLOOMBERG EQ

Any ideas?

 

[jondavis1987]

=IF(AC5="ISSUE PRICE",AD,"BLOOMBERG "& ",AD5)

wouldn't that work for what you're needing?

 

[jondavis1987]

=IF(AC5="ISSUE PRICE",AD,"BLOOMBERG "& AD5)

 

[Fluff]

How about
=IF(AD5="Issue price","ISSUE PRICE","Bloomburg " & AD5)

 

[mrsushi]

Thank you for the amendment. How can this be amended even more if there is no data in AD so cell AB will be blank?

Many thanks

 

[Vathana]

That would be: =IF(OR(AD5="",AD5="ISSUE PRICE"),AD5,"BLOOMBERG " & AD5)

 

[mrsushi]

That would be: =IF(OR(AD5="",AD5="ISSUE PRICE"),AD5,"BLOOMBERG " & AD5)

That's perfect. Many thanks Vathana