=IF(B19="STG","IMC COE",IF(B19="SWG","SWG IMC",IF(B19="S&D","S&D
IMC",IF(B19="IGF","IGF IMC",IF(B19="GTS","GTS IMC",IF(B19="GBS","GBS
IMC",IF(B19="Alliances","Alliances IMC" )))))))

Here B19=D6 and type the above in D7. However we have a limitation of using
only 7 ifs.

"Karen Smith" wrote:

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