Results 1 to 20 of 20

IF AND OR complex statement for accepting limits in a tolerance range

Threaded View

maggiedort IF AND OR complex statement... 08-22-2013, 10:12 AM
daffodil11 Re: IF AND OR complex... 08-22-2013, 10:24 AM
maggiedort Re: IF AND OR complex... 08-22-2013, 10:28 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 10:43 AM
maggiedort Re: IF AND OR complex... 08-22-2013, 10:50 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 10:53 AM
maggiedort Re: IF AND OR complex... 08-22-2013, 10:56 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 11:00 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 11:01 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 10:58 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 11:03 AM
daffodil11 Re: IF AND OR complex... 08-22-2013, 11:11 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 11:12 AM
maggiedort Re: IF AND OR complex... 08-22-2013, 11:14 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 11:18 AM
daffodil11 Re: IF AND OR complex... 08-22-2013, 11:15 AM
maggiedort Re: IF AND OR complex... 08-22-2013, 11:16 AM
maggiedort Re: IF AND OR complex... 08-22-2013, 11:26 AM
L-Drr Re: IF AND OR complex... 08-22-2013, 11:29 AM
maggiedort Re: IF AND OR complex... 08-22-2013, 12:22 PM
  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Illinois
    MS-Off Ver
    Excel 2010
    Posts
    8

    IF AND OR complex statement for accepting limits in a tolerance range

    I keep getting the "Too Many Arguments" notice for this equation and I'm wondering if anyone out there can come up with A) either the proper formula; or B) a better way to do it.

    I have this form that is used in production. The guys filling it out put in the criteria and the form is supposed to tell them if it's acceptable or not acceptable.

    I've attached a sample with any sensitive material removed.
    Essentially, what should happen is:
    If cells H, I, J, K, or L are greater than cell E but less than cell D, cell O should mark with an "X" for acceptable.
    If any of those cells do not fall within the limits of cells E and D, cell P should mark with an "X" for not acceptable.

    The problem with my formula is that it's requiring cell H:L to fall within the limits for the "X" to mark acceptable when in reality if only cell H is filled in (as long as it's within limit), the form should be marked acceptable.

    I've thought about switching the formula so that instead of having two separate formulas for cells O(acceptable) and P(not acceptable), we have one field where the value if true would mark Acceptable and the value if false would mark Not Acceptable...but i'm still having trouble working that logic...

    Here are my formulas as they stand:
    For cell O (Acceptable):
    =IF(D4>0,"",IF(E4="","",IF(AND(D4>=0,E4>=0,H4<=D4,H4>=E4,I4<=D4,I4>=E4,J4<=D4,J4>=E4,K4<=D4,K4>=E4,L4<=D4,L4>=E4),"X","")))

    For cell P (Not Acceptable):
    =IF(OR(AND(H4>0,OR(H4<E4,H4>D4)),AND(I4>0,OR(I4<E4,I4>D4)),AND(J4>0,OR(J4<E4,J4>D4)),AND(K4>0,OR(K4<E4,K4>D4))),"X","")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2012, 12:00 PM
  2. return number from range if in tolerance
    By BHudPE in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2011, 04:21 PM
  3. Compare numbers to a tolerance range
    By C2AUTOINC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-30-2009, 06:16 PM
  4. worbook.name not accepting range value
    By suzetter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2005, 06:05 AM
  5. If Statement Limits
    By Lambright44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2005, 09: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