Multiple If statement not workign

HI-

I am trying to create an if statement where if the name in cell b72 = the name I want, then I want it to return a different version of that name, if not, then just return the name in b72. When I put below statement in I receive a #NAME?

Please Login or Register  to view this content.

Thanks

You need quotes around the text strings

I would guess like this

=IF(B72="Merrill-CW14 MSCI Daily TR", "Merrill Lynch Intl + CO",B72)

Thanks, those worked.

You're welcome.