Ventana software support forum

Posted: **Wed Feb 06, 2013 9:53 am**

Hi
I am wondering how to combine multiple "IF THEN ELSE " statements in the same equation.i.e. how to I represent in a single equation 3 or 4 conditions of a statement with he same IF THEN ELSE equation?

Posted: **Wed Feb 06, 2013 10:45 am**

I would try to avoid it where possible as it can make things tricky to debug.

There are two ways. Either embed them

Code: Select all

result = IF THEN ELSE ( a > b , c , IF THEN ELSE ( a > d , e, 0 ) )

or add them (this is my preferred option as I find it clearer).

Code: Select all

result = IF THEN ELSE ( a > b , c , 0 )
+ IF THEN ELSE ( a > d , e , 0 ) )

Posted: **Wed Feb 06, 2013 11:16 am**

many thanks

Ventana software support forum

multiple IF THEN ELSE equatios

multiple IF THEN ELSE equatios

Re: multiple IF THEN ELSE equatios

Re: multiple IF THEN ELSE equatios