+ Reply to Thread
Results 1 to 9 of 9

Formula Fail or Pass

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    costa rica
    MS-Off Ver
    Office365
    Posts
    28

    Formula Fail or Pass

    Hi Guys ,

    Could you please help me to finish my formula.

    I want to put Pass or Fail based in a dropdown selection and two conditions;

    1- The first condition of the dropdown is : Quality Level that could be : High Quality Or Standard
    2- The second condition is based in a value :Standard >20 = Fail High Quality >10 = Fail

    Attached my excel with the formula I created THAT works for only High Quality .

    Any advise could be great !! Thanks

    Formula Fail or Pass.xlsx

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Formula Fail or Pass

    are you still using excel version 2003, thats quite old

    so this will work on 2003 version

    how about

    =IF(AND($C1="High Quality", C4<=10), "Pass", IF( AND($C1="Standard", C4<=20),"Pass","Fail"))

    OR

    =IF(OR( AND($C1="Standard", C4<=20), AND($C1="High Quality", C4<=10)), "Pass","Fail")
    Attached Files Attached Files
    Last edited by etaf; 08-24-2022 at 12:27 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    08-24-2022
    Location
    Indonesia
    MS-Off Ver
    O365
    Posts
    5

    Re: Formula Fail or Pass

    Hi Carol,

    How about this

    =LET(hq,IF(AND($C1="High Quality", C4<=10), "Pass", "Fail"),std,IF(AND($C1="Standard", C4<=20), "Pass", "Fail"),IF(C1="High Quality",hq,std))

  4. #4
    Registered User
    Join Date
    10-20-2010
    Location
    costa rica
    MS-Off Ver
    Office365
    Posts
    28

    Re: Formula Fail or Pass

    crazy works perfectly !!!

  5. #5
    Registered User
    Join Date
    10-20-2010
    Location
    costa rica
    MS-Off Ver
    Office365
    Posts
    28

    Re: Formula Fail or Pass

    Quote Originally Posted by eddor View Post
    Hi Carol,

    How about this
    amazing thanks a lot

  6. #6
    Registered User
    Join Date
    10-20-2010
    Location
    costa rica
    MS-Off Ver
    Office365
    Posts
    28

    Re: Formula Fail or Pass

    Quote Originally Posted by etaf View Post
    are you still using excel version 2003, thats quite old

    so this will work on 2003 version

    how about

    =IF(AND($C1="High Quality", C4<=10), "Pass", IF( AND($C1="Standard", C4<=20),"Pass","Fail"))

    OR

    =IF(OR( AND($C1="Standard", C4<=20), AND($C1="High Quality", C4<=10)), "Pass","Fail")
    just perfect !!! thanks a lot for your time

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Formula Fail or Pass

    you are welcome

    are you still using excel version 2003, thats quite old
    LET () will not work with version 2003

    its important to keep the version of excel you are using updated on your profile. Solutions will vary a lot now as later versions and 365 version has a lot more different functions available

    would you update your profile please to the current version

  8. #8
    Registered User
    Join Date
    08-24-2022
    Location
    Indonesia
    MS-Off Ver
    O365
    Posts
    5

    Re: Formula Fail or Pass

    Yeah u right etaf, sorry I skipped to check Carol excel version

  9. #9
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Formula Fail or Pass

    Yeah u right etaf, sorry I skipped to check Carol excel version
    was aimed more at the OP not you
    i dont think they are using 2003 - as post 5 - indicates LET worked OK for OP
    Hence qhy i suggested we needed the profile updated , but no reply so far on version

+ 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. Pass/Fail Formula Issue
    By cjb0723 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-07-2020, 02:42 PM
  2. Formula to determine Pass/Fail
    By joeyjee in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-04-2018, 02:24 PM
  3. [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
  4. Formula Help with Pass/Fail function
    By bna1219 in forum Excel General
    Replies: 1
    Last Post: 12-10-2014, 09:57 AM
  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

Tags for this Thread

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