IF Formula (Basic)

[MOlinski]

Hello,

I am working on a workflow and need to update my IF statement below. We just added a "Monthly" pay group, so now it is not just Semi-Monthly and Weekly. I am trying to get it to W = Weekly, S = Semi-Monthly, and M=Monthly. But am having a hard time figuring it out, any assistance would be greatly appreciated.

[Felipe_Ribeir0 · Accepted solution]

Hi @MOlinski 

Try this expression:

[Pay Group] + '_'
+

IF Contains([Feq], "W") THEN "Weekly "
ELSEIF Contains([Feq], "M") THEN "Monthly "
ELSE "Semi-Monthly "
ENDIF

[binuacs · Accepted solution]

@MOlinski One way of doing this