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)