Pages:
Actions
  • #1 by 1oser on 06 Aug 2014
  • I really like the "IF" conditions and hope we can get it extended.

    I've done some crazy stuff .. multiple nested IF's

    IF(r_1_back_price < 1.5, lay_price * 0.9, IF(r_1_back_price < 1.85, lay_price * 0.8,IF(r_1_back_price < 2.25, lay_price * 0.7, IF(r_1_back_price < 3, lay_price * 0.75, lay_price * 0.6))))


    I would like and (&&), or (||) added.

    IF( a > b && d < c, true, false)
    IF( a > b || d < c, true, false)
  • #2 by Tim (WellDoneSoft) on 06 Aug 2014
  • IF(AND(a>b,d<c), true, false)
    IF(OR(a>b,d<c), true, false)
Pages:
Actions