Subscribe Bookmark RSS Feed

Spec Limit and Pass/Fail Column

adam

Contributor

Joined:

Sep 20, 2017

Hi,

 

I would like to ask if I set a particular column with spec limit(eg. low:100 and max:1000), from this limit set how can I create a corresponding column say Pass/Fail column to label those data within limit as Pass and out of spec as Fail.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
adam

Contributor

Joined:

Sep 20, 2017

Solution
I guess I found the answer from another discussion :) Thanks!
By setting the Formula(in column properties, and use conditional IF function works fine.

If( 100 <= :MAX_MIN Test <= 1000,
"Pass",
"Fail"
)
1 REPLY
adam

Contributor

Joined:

Sep 20, 2017

Solution
I guess I found the answer from another discussion :) Thanks!
By setting the Formula(in column properties, and use conditional IF function works fine.

If( 100 <= :MAX_MIN Test <= 1000,
"Pass",
"Fail"
)