2 Replies Latest reply: May 15, 2014 10:08 AM by mizzfit _ RSS

    IF Syntax

    mizzfit _



      I am trying to use a calculated field IF statement ... please help me with my syntax.


      If(OnHand<=OrderPt,'ORDER MORE','STOCK OK')


      This is not correct obviously or I would not be posting. I get "The expression for this calcularted field cannot be evaluated. Please go to the "Formula" tab to fix the expression". Any help would be appreciated.