Author Topic: IF stament doesn't seem to work  (Read 3190 times)

Tags:
  • All members
  • Posts: 6
  • Karma: +0/-0
IF stament doesn't seem to work
« on: Wed, 13 November, 2019, 21:44 »
Hi Guys

I am running a small loss recovery system in poker. I divide the last X losses by 3 when the losses reach a value. Sometimes when recovery starts the division sum will be under £1 so I have attempted an IF statement which doesn't appear to work?

IF(last_lost/3<1,1,last_loss/3)

am I correct in deciphering the above to

if last_lost divide by 3 is less than 1 return 1 else return last_loss divided by 3

If someone could just correct it for me that would be great.

Thanks in advance

  • All members
  • Posts: 958
  • Karma: +46/-2
Re: IF stament doesn't seem to work
« Reply #1 on: Thu, 14 November, 2019, 14:10 »
Firstly, you are using 2 different variables:  last_lost & last_loss  or is that just a typo?


  • All members
  • Posts: 6
  • Karma: +0/-0
Re: IF stament doesn't seem to work
« Reply #2 on: Thu, 14 November, 2019, 21:30 »
Ouch, yes typo, it is now working as expected. Thanks

  • All members
  • Posts: 6
  • Karma: +0/-0
Re: IF stament doesn't seem to work
« Reply #3 on: Mon, 18 November, 2019, 21:41 »
Need some help, I have a user variable set called 'behind' it goes up if the bank grows and remains at that value when losses are happening. Using

IF(last_lost/3<1,1,last_lost/3) ----> typo fixed ;)

It losses out on the amount to recover so I would like to run with

IF(behind/3<1,1,behind/3)

How do I set up the trigger condition? I have tried user_variable ---- behind but only get the option of is set is is not set. What should I use?

Thanks

  • All members
  • Posts: 6
  • Karma: +0/-0
Re: IF stament doesn't seem to work
« Reply #4 on: Mon, 18 November, 2019, 22:06 »
Forgot to say why it losses out, it's when a dead heat happens, the win is less than expected using last_lost