If and Replace condition

[TB_Mylene]

I believe this is a simple formula but I'm drawing a blank. I need help in replacing column A.

If ChainName = Walmart USA, replace StoreName with Walmart. Can someone help me with this formula?

Thanks in advance.

[flying008 · Accepted solution]

Hi,@TB_Mylene 

Output Column: [StoreName]

Formula : IIF([ChainName]="Walmart USA","Walmart",[StoreName])

[TB_Mylene]

@flying008 Thank you so much! You are a life saver!