Multiple IF statements

[#1]

Hi everyone,

looking for some help with IF statements. Basically I would like to setup multiple "if conditions" in one expression... but I cannot seem to get it to work.

Example:

if(WildMatch(UNIT_TYPE,'*I*'), UNIT_TYPE) or

if(WildMatch(UNIT_TYPE,'*O*'), UNIT_TYPE) or

if(WildMatch(UNIT_TYPE,'*E*'), UNIT_TYPE)

Even if I replace "or" with "and" it does not work. Any ideas on how I can do this?

[Anonymous · Accepted solution]

Try this...

if(WildMatch(UNIT_TYPE,'*I*') or WildMatch(UNIT_TYPE,'*O*') or WildMatch(UNIT_TYPE,'*E*'), UNIT_TYPE)

[jonathandienst]

If(WildMatch(UNIT_TYPE,'*I*', '*O*', '*E*'), UNIT_TYPE)

Jonathan

[jagan]

Hi,

Try this

if(WildMatch(UNIT_TYPE,'*I*', '*O*', '*E*'), UNIT_TYPE)

Hope this helps you.

Regards,

Jagan.

[#5]

Thank you everyone!