Formula for Replacing a value in a column

aliciadavoudpour

Hi! I have data in alteryx that looks like this:

Brand	Model
Apechete	Chare
Apechete	Chare
Apechete	Crux
Apechete	Chare

I am trying to create a formula that replaces the value "Crux" in the model column to say "Chare" if brand="Apechete. 

I figure you use a formula that looks something like: IF[Brand]="Apechete" and [Model]="Crux" then REPLACE ....

can't figure out the replace part

MarqueeCrew

@aliciadavoudpour ,

so close. 

If [brand] = "Apechete" AND [model] = "Crux"

     THEN "Chare"

Else

[Model]
Endif

 use that in a formula tool and you should be good to go. 

cheers,

 mark