Testing against a variable inside an IF function

Hi Guys,

Has anyone found the solution to create an IF-function within IDEA to test something against a variable?

To be more precise, I was hoping to create a new field, which gives me the text "EMAIL" if the variable {JobDepartment} is defined as "EMAIL" or to give me the value in the column [JOB].

I have tried the below equation, but this one does not seem to work unfortunatelly:

Dim JobDepartment As String
JobDepartment = "EMAIL"

field.Equation = "@If(" & JobDepartment & " = ""EMAIL""; ""EMAIL""; JOB)"

I'm rerunning this script to test the completion of a set of trainings, whereas most a Job or Department related, but 1 is related to a whether a team member has his/her own e-mail account.
Many thanks!
Anton