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

    IF Syntax

    mizzfit _

      Hi,

       

      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.

       

      Thanks!