+ Reply to Thread
Results 1 to 3 of 3

formula for pass/fail/undefined

  1. #1
    Registered User
    Join Date
    08-31-2018
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    2

    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. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    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"))
    Last edited by shg; 08-31-2018 at 07:54 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    08-31-2018
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    2

    Re: formula for pass/fail/undefined

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to determine Pass/Fail
    By joeyjee in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-04-2018, 02:24 PM
  2. [SOLVED] Formula for pass,fail,credit(if,and,or)
    By cathal1292 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-02-2016, 06:01 AM
  3. Formula Help with Pass/Fail function
    By bna1219 in forum Excel General
    Replies: 1
    Last Post: 12-10-2014, 09:57 AM
  4. [SOLVED] Need help with formula to return value of Pass or Fail
    By bearligirl89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-15-2013, 01:06 PM
  5. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  6. Help with Pass / Fail Formula
    By milovisk in forum Excel General
    Replies: 4
    Last Post: 03-20-2012, 02:57 PM
  7. Formula Help with Pass/Fail function
    By Spyroviper in forum Excel General
    Replies: 3
    Last Post: 02-04-2009, 01:02 PM

Bookmarks

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