Expression using IF

[chaiwaykeat]

I have problem posting logical expression using IF can someone please advise ?

[teiswamsler]

Hi Chaiwaykeat

You cant use ELSE in a if statement in the frontend. You have to build your expression as a nested if.

ex.
If(Condition, Output, If( Condition, Output, else ))


Br.
Teis

[davidfdezcalleja]

To make nested IFs the structure would be as follows:

If (

condition Expression,

then_expr Expression

[,else_expr Expression]

)

ELSE reserved word is not used.

[Kushal_Chawda · Accepted solution]

It should be something like below

=if ( (Avg. Expression 1) >= (Avg. Expression 2),

(Avg. Expression 1),

(Avg. Expression 1) )