# formula for pass/fail/undefined

1. ## formula for pass/fail/undefined

hi everyone, new here.

Need help for my spreedsheet. heres the case:

sample1
(b2) measured value : 9
(c2) low limit : 9
(d2) high limit : 11
(e2) uncertainty : +/- .02
(f2) result : undefined

sample2
(b2) measured value : 9.05
(c2) low limit : 9
(d2) high limit : 11
(e2) uncertainty : +/- .02
(f2) result : pass

sample3
(b2) measured value : 8.5
(c2) low limit : 9
(d2) high limit : 11
(e2) unceratinty : +/- .02
(f2) result : fail

say i have a measured value of 9 with uncertainty value of +/- .02, or (8.98 - 9.02), the result of this should declare "undefined", but if the measured value is inside the upper and lower limit (sample2 - measured value 9.05 +/-.02 or (9.03-9.07)), this should declare "pass" and "fail" if outside both limits of high and low (sample3 - measured value 8.5 +/- .02 or (8.48-8.52)).

hope my inquiry makes sense. been trying to solve this and search for solution for almost a week.

thank you very much in advance.

2. ## Re: formula for pass/fail/undefined

 A B C D E 1 sample1 sample2 sample3 2 measured value 9 9.05 8.5 3 low limit 9 9 9 4 high limit 11 11 11 5 uncertainty 0.02 0.02 0.02 6 result uncertain pass fail B6: =IF(AND(B2-B5 >= B3, B2+B5 <= B4), "pass", IF(OR(B2+B5 < B3, B2-B5 > B4), "fail", "uncertain"))

3. ## Re: formula for pass/fail/undefined

Thank you very very much SHG...this is perfect. problem solved.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1