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