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

Tags:
  • All members
  • Posts: 332
  • Karma: +7/-2
Logical Operators upgrade.
« on: Wed, 14 November, 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: 4458
  • Karma: +252/-10
  • Gender: Male
*
Re: Logical Operators upgrade.
« Reply #1 on: Wed, 14 November, 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: 332
  • Karma: +7/-2
Re: Logical Operators upgrade.
« Reply #2 on: Wed, 14 November, 2018, 13:55 »
Did not know this.

Add it as an example to the help manual!

  • √Člite
  • Posts: 4458
  • Karma: +252/-10
  • Gender: Male
*
Re: Logical Operators upgrade.
« Reply #3 on: Wed, 14 November, 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: 332
  • Karma: +7/-2
Re: Logical Operators upgrade.
« Reply #4 on: Thu, 15 November, 2018, 08:16 »
OK great..! Add THAT to the manual too! Even better.

  • All members
  • Posts: 332
  • Karma: +7/-2
Re: Logical Operators upgrade.
« Reply #5 on: Thu, 15 November, 2018, 08:23 »
.....and I see THAT is already in the manual...Jolly good carry on as you were! 8)