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

Tags:
  • All members
  • Posts: 334
  • Karma: +8/-2
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: 4458
  • Karma: +252/-10
  • 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: 334
  • Karma: +8/-2
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: 4458
  • Karma: +252/-10
  • 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: 334
  • Karma: +8/-2
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: 334
  • Karma: +8/-2
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)