nested if in trigger

i would like calculate lay based on previous wins
im using

IF(wins=1,ba*2,IF(wins=3,ba*2,IF(wins=5,ba*2,IF(wins=7,ba*2,ba))))

but not working

here ba = lay amount

or

IF(OR(wins=1,wins=3,wins=5,wins=7,wins=9),ba*2,ba)

which one correct

Both expressions are syntactically correct, although the first one is less efficient and more redundant.

They are not identical though: the first expression will return ba in all cases except when the number of wins is 1, 3, 5 or 7.

The second one will return ba in all cases except when the number of wins is 1, 3, 5, 7 or 9.

If something is not working, try to analyse the logs and see where the error sits.

Quote from: Oxa (WellDoneSoft) on 30 Oct 2014, 10:11

Both expressions are syntactically correct, although the first one is less efficient and more redundant.

They are not identical though: the first expression will return ba in all cases except when the number of wins is 1, 3, 5 or 7.

The second one will return ba in all cases except when the number of wins is 1, 3, 5, 7 or 9.

If something is not working, try to analyse the logs and see where the error sits.

i tried both not returning ba*2 in any case , even trigger's no of win after lose is =1,3,5 or 7

always returning value ba only

here ba is lay amount

i need to double my lay amount when trigger's no of win after lose is =1,3,5 or 7 or 9

can you help me with that code

Perhaps something else was set up incorrectly, it's not only down to that formula, the general rule of a thumb is to look in the logs.

The basic trigger would be like the one attached.

Thanks. It would be nice though if someone can find a way to do this.

nested if in trigger

Hello Guest