Multi-Condition IF THEN ELSE statement

[phil_budden]

Hi All,

I was wondering if anyone knows of a way to do a multi-condition 'IF THEN ELSE' statement in the formula tool,

I want to replace the contents of a string but only if two conditions are met, so for example:

Output Field

[FIELD 1]

IF [FIELD 2] = "X" and [FIELD 3] = "Y" THEN "Replacement Text" ELSE [FIELD 1] ENDIF

Alternitivly is there a better way to acheive this?

Thanks in advance...

[JohnJPS · Accepted solution]

Your solution looks good to me.  I don't think you can simplify it further than that.

[phil_budden]

Hi John,

Thanks for the quick response - when I was typing it as I did in the example I was getting an error about an unrecognised variable "and" so assumed there had to be another way to do this.  After you pointed out this was the correct way to do it I retyped the formula and this time it worked - must have been a typo in there!

Thanks again.

[JohnJPS]

Wild guess: a space in the "ENDIF" ... that one has gotten me often enough to be memorable.

[phil_budden]

Hah, quite possibly

[jdunkerley79]

I tend to prefer the IIF for simple statements as have made that mistake too often!

[phil_budden]

I've not used the IIF before, how does it differ from using IF THEN ELSE?

[JohnJPS]

In a nutshell:

IF c THEN t ELSE f ENDIF

(is the same as)

IIF(c,t,f)

[jdunkerley79]

It stands for inline if

IIF(<condition>,<true expression>,<false expression>)

Is a nice compact form.

[phil_budden]

Great, less typing, will definitely make use of this going forward - thanks both