AnsweredAssumed Answered

Pass Fail reporting for an acceptable range

Question asked by jenchem on Jan 30, 2020
Latest reply on Feb 14, 2020 by jenchem

I am trying to add Pass/Fail functions to my reports for my results.  I successfully set one up for the %RSD of my system suitability.  I stored the %RSD as a variable and then used an If statement to say that if it was less than 2 it says "Pass" otherwise it says "Fail".  However, I could not get an equation to work for when the value must be in a specific range.  For instance my check standard recovery must be between 98.0 and 102.0%.  In Excel I would nest an AND statement in the If statement but I could not get that to work here.

Outcomes