Pages:
Actions
  • #1 by liltbrockie on 14 Nov 2018
  • 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;
    )

  • #2 by mcbee on 14 Nov 2018
  • hi

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


    mcbee
  • #3 by liltbrockie on 14 Nov 2018
  • Did not know this.

    Add it as an example to the help manual!
  • #4 by mcbee on 14 Nov 2018
  • hi
    it is basic excel formulea.

    mcbee
  • #5 by liltbrockie on 15 Nov 2018
  • OK great..! Add THAT to the manual too! Even better.
  • #6 by liltbrockie on 15 Nov 2018
  • .....and I see THAT is already in the manual...Jolly good carry on as you were! 8)
Pages:
Actions