Author Topic: Logical Operators upgrade.  (Read 1635 times)

Tags:
  • All members
  • Posts: 347
Logical Operators upgrade.
« on: 14 Nov 2018, 11:52 »
Hi there... nested IF's are great but can we have something a little more elegant?

1. Can we allow for AND, OR operators in IF statements?

eg:

IF(1>0 AND 2>2,10,-10) retursn -10

2. Can we have CASE statements?

eg:

CASE(
X=1;100;
X=2;200;
)


  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: Logical Operators upgrade.
« Reply #1 on: 14 Nov 2018, 13:28 »
hi

Quote
IF(1>0 AND 2>2,10,-10) retursn -10
try IF(AND(1>0,2>2),10,-10)


mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 347
Re: Logical Operators upgrade.
« Reply #2 on: 14 Nov 2018, 13:55 »
Did not know this.

Add it as an example to the help manual!

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: Logical Operators upgrade.
« Reply #3 on: 14 Nov 2018, 13:58 »
hi
it is basic excel formulea.

mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 347
Re: Logical Operators upgrade.
« Reply #4 on: 15 Nov 2018, 08:16 »
OK great..! Add THAT to the manual too! Even better.

  • All members
  • Posts: 347
Re: Logical Operators upgrade.
« Reply #5 on: 15 Nov 2018, 08:23 »
.....and I see THAT is already in the manual...Jolly good carry on as you were! 8)

 

Please note, BetFair is seems to be currently OFFLINE