Try:

=IF(D6="STG","IMC
COE",IF(OR(D6="SWG",D6="S&D",D6="IGF",D6="GTS",D6= "GBS",D6="Alliance"),D6&"
IMC",""))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Karen Smith" wrote in message
...
I need a formula for the following:

If D6=STG, then place "IMC COE" in cell D7
If D6=SWG, then place "SWG IMC" in cell D7
If D6=S&D, then place "S&D IMC" in cell D7
If D6=IGF, then place "IGF IMC" in cell D7
If D6=GTS, then place "GTS IMC" in cell D7
If D6=GBS, then place "GBS IMC" in cell D7
If D6=Alliances, then place "Alliances IMC" in cell D7