Results 1 to 4 of 4

Need help with Nested formula IF, AND, OR to create status report

Threaded View

Pelagie Need help with Nested formula... 02-11-2014, 03:52 AM
Pete_UK Re: Need help with Nested... 02-11-2014, 06:15 AM
Pelagie Re: Need help with Nested... 02-11-2014, 07:07 AM
Pelagie Re: Need help with Nested... 02-12-2014, 08:21 AM
  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Brasov
    MS-Off Ver
    Excel 2007
    Posts
    3

    Need help with Nested formula IF, AND, OR to create status report

    Supplier complains.xls
    Dear all, I have an excel status report, in which I try to make a formula to show the status, low, medium,high, depending on the drop down list combinations of characteristics choosen in the previous 6 colomns.
    Please see attached file.

    THis is how formula looks like:
    Formula: copy to clipboard
    =IF(OR(AND(D7="Incoming [1]");AND(OR(E7="Package [1]";E7="Identität [2]"));AND(OR(F7="Parts can be used with reservation [1]";F7="Defective parts sorted out [2]"));AND(OR(G7="no [1]";G7="yes [2]"));AND(H7="N/A");AND(OR(I7="Systematic [1]";I7="Single [2]")));"low";IF(OR(AND(OR(D7="Incoming [1]";D7="Production [2]"));AND(OR(E7="Package [1]";E7="Appeareance [3]";E7="Dimensional damage(crack)[4]";E7="Identität [2]"));AND(OR(F7="Parts can be used with reservation [1]";F7="Defective parts sorted out [2]";F7="Return [3]"));AND(OR(G7="no [1]";G7="yes [2]"));AND(H7="N/A)[1]");AND(OR(I7="Systematic [1]";I7="Single [2]")));"medium";IF(OR(AND(OR(D7="Incoming [1]";D7="Production [2]";D7="Costumer [3]"));AND(OR(E7="Package [1]";E7="Appeareance [3]";E7="Dimensional damage(crack)[4]";E7="Identität [2]";E7="Function[5]"));AND(OR(F7="Parts can be used with reservation [1]";F7="Defective parts sorted out [2]";F7="Return [3]";F7="Containment Level [5]"));AND(OR(G7="no [1]";G7="yes [2]"));AND(OR(H7="yes (100% sorting, escalation level)[5]";H7="no (request 8D or statement)[1]";H7="N/A)[1]"));AND(OR(I7="Systematic [1]";I7="Single [2]")));"high";"")))


    I put up the formula I worked on, first part is working, than when should return medium or high is not working anymore.
    If you have anyother idea that I can create this report , or to fix formula, will be very happy to discuss it. Please also take in consideration I need to make graphic after this report afterwards.
    Thank you so much and hardly wait for your feed-back!
    Last edited by Pelagie; 02-11-2014 at 04:24 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Project status report
    By maximpinto in forum Excel General
    Replies: 1
    Last Post: 11-24-2013, 07:50 AM
  2. Status Report Workbook??
    By mig1980 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2012, 07:53 PM
  3. Replies: 0
    Last Post: 02-14-2012, 12:31 PM
  4. Transportation Status Report
    By kemp3524 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2007, 12:57 PM
  5. AutoFilter report in status bar
    By 1scant in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 04:25 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