Forum Discussion
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 https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90 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 https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90 tool.
Thank you very much ! I just replaced the , by ; in your formula and it worked!
