Forum Discussion
Solved
What's the best Formula
Good Afternoon,
I have a column with : Leather goods, Denim, Jersey, Accessories etc. For every cell that is equal to denim or jersey or coat or even shirts I would like to replace it by RTW, i would like the other celles (leather goods, handbags or accessories) to remain as is.
What's the best formula ?
Thanks!
Ch
Hi,
You can depend on a formula like this one:
=IF(OR(A1={"jersey";"coat";"denim"}),"RTW",A1)Also, you can use Find and Replace tool.
2 Replies
Hi,
You can depend on a formula like this one:
=IF(OR(A1={"jersey";"coat";"denim"}),"RTW",A1)Also, you can use Find and Replace tool.
Thank you very much ! I just replaced the , by ; in your formula and it worked!
