2 Replies Latest reply on Sep 19, 2017 3:46 PM by ryoboyle

    TROUBLE IN IFF STATEMENT

    rajesdeo

      Can Someone help me in converting below logical statements to IR.

       

       

      Statement

      IF Assay>99 And Assay<101 ,Then "Pass" Otherwise Display "Fail"

       

      Syntax I used

      =Iif(99<Assay<101,"Pass","Fail")

       

      But results I am getting as below Always Pass

       

       

      Thanks & Regards

      Rajesh Deo