multiple IF THEN ELSE equatios

[oludot5]

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?

[Administrator]

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 ) )

[oludot5]

many thanks