Best way to write formula

[cyreports]

What would be the best way to write this formula? It the SFFormOfDeclaration = "W-2" or "1099" then I want an "X" else nothing. Would I just want to use multiple IF THEN Statments or could I use a IN Statement??

IF {rpPatProfile.SFFormOfDeclaration} = "W-2" THEN "X"

 

[hilfy]

Personally, I would write it as:

IF {rpPatProfile.SFFormOfDeclaration} = "W-2" or {rpPatProfile.SFFormOfDeclaration} = "1099" THEN "X"

I'm sure there's a way to do it using an IN statement, but this works just as well.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[jlopeman]

As hilfy mentioned, here's the IN statement. Either works.

IF {rpPatProfile.SFFormOfDeclaration} IN ["W-2","1099"] then "X