Pass Fail reporting for an acceptable range

Question

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.

ryoboyle · Accepted Answer

Hello, Just to add on to dnprulz 's reply, the expression that he provided will work in OpenLab Custom Calculator and should perform what you are looking to do. However, if you want the pass/fail logic to be set on the report template then you will want to use the IIf() function as opposed the if() function. You will also need to substitute the 'x' used in the expression for the value that want to compare to the pass/fail limits.

Andy Wright · Answer

Hi jenchem

I know the question has been answered. An alternative to the nested IF/IIF function from dnprulz is to use some boolean logic in a single IF/IIF statement

For use in a report template, the function would be

=IIF(SavedRTRSD > 98 AND SavedRTRSD < 102, "Pass", "Fail")

I guess that you couldn't get the function to work when you tried because you may not have repeated the name of the variable used to store the %RSD.

/Andy

Pass Fail reporting for an acceptable range

Top Replies