Need formula to replace an incorrect value within a combination with another value

[Jack5]

Hi all,

I have a dataset that has information on car brands and associated models. There is a brand/model combination within the dataset that has the incorrect model (Crux) associated with a brand (Apechete) and the incorrect model needs to be replaced with the correct model (Chare). I need to use the formula tool to accomplish this replacement. Can someone please help me come up with a working formula?

[atcodedog05 · Accepted solution]

Hi @Jack5 

Use this formula tool column model

IF [model]="Crux" and [brand]="Apechete" then "Chare"

Else [model] endif

[atcodedog05 · Accepted solution]

Hi @Jack5 

Here is a workflow for the task.

Input:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Jack5]

That worked, thanks!

[atcodedog05]

Happy to help 🙂 @Jack5 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂