Help needed with String Formula

[Anee]

Data has 2 columns - Employment Type and Global Career Band - both V_String

Trying to write a formula like below. However, not getting the desired result. No change infact in the output and input. I am sure I am not using the correct syntax for the piece in formula highlighted in red, which is whatever is there in Global Career Band, overwrite with 'Not Applicable'

if Contains([Employment Type], "Service Provider")
Then Replace([Global Career Band], "*" , "Not Applicable")
Else [Global Career Band]
Endif

[Deano478]

@Anee We will need to see the data so that we can adjust the formula accordingly

[Qiu · Accepted solution]

@Anee 

You are tryting to use the * as wild card?

If that is the case, try this one

if Contains([Employment Type], "Service Provider")
Then Replace([Global Career Band], [Global Career Band] , "Not Applicable")
Else [Global Career Band]
Endif

---

or just simply

if Contains([Employment Type], "Service Provider")
Then "Not Applicable"
Else [Global Career Band]
Endif

---

[Anee]

Thanks @Qiu for the quick turnaround. It worked!!