IF Formula Help

[arundaka03]

Hi everyone

Quite new to Alteryx Designer and need some help with a conditional statement - think I need to do a nested IF but need some help writing the formula in the formula tool 

I want to do the following:

My gender identity is different than my sex at birth	New column and desired output
No	Same as birth gender
Yes	Different than birth gender
Prefer not to answer	Prefer not to answer

Last row is blank. If blank, need the new column to be blank too.

Thanks,
KA

[Qiu · Accepted solution]

@arundaka03 
We can use a Switch function

[AngelosPachis]

Hi @arundaka03 ,

Here are two ways you can do it, one is using an IF statement like you said, the other is a Switch statement, which works similar to an if statement but looks nicer and cleaner if you have many clauses sometimes