+ Reply to Thread
Results 1 to 6 of 6

Too many Nested arguments > 7

  1. #1
    Registered User
    Join Date
    11-15-2018
    Location
    Bristol
    MS-Off Ver
    Office 365
    Posts
    2

    Too many Nested arguments > 7

    Hi Please help

    I trying to create an estimating system for a product. The price varies by size, so I've created an array which can be looked up. It works fine until I go beyond 7.

    The formula is as follows : if (C10="Product_B",vlookup(Value,Array,column,0),if(C10="Product_C",vlookup(Value,array,column,0), etc

    However once I get beyond 7 arguments I get an error message of too many arguments. I am using 2003. What is the fix please ( with an example)

    thanks

    Nick

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Too many Nested arguments > 7

    You already have an example... so can we see it?

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever). Please don't attach a picture of an Excel sheet (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-15-2018
    Location
    Bristol
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Too many Nested arguments > 7

    Please find attached example

    I've kept it simple- on the quote page select size and Product and Price will appear. On full working model once I get beyond 7 products i get an error message
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Too many Nested arguments > 7

    Your data layout will cause you to experience: grief, frustration, weeping & wailing, and gnashing of teeth!!!

    Can I suggest that you add a new column A and include the product name on EVERY line. Then it becomes soooo simple. Is that possible?

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Too many Nested arguments > 7

    Here's a formula with the adapted layout:

    =INDEX(Prices!$C$10:$C$347,MATCH(1,INDEX((Prices!$A$10:$A$347=Quote!D8)*(Prices!$B$10:$B$347=Quote!B8),0),0))

    It's easy to make the data validation a bit smarter, too... if you're interested.
    Attached Files Attached Files

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Too many Nested arguments > 7

    Or try this
    Enter in B14
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. [SOLVED] Help with Nested IF arguments, please
    By KWiseman in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-13-2018, 04:23 AM
  2. Too many arguments in nested if function
    By floridashaughn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 02:23 PM
  3. I am having an issue with an IF formula that contains 4 nested arguments....
    By iamjustinpowell in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2013, 04:00 PM
  4. [SOLVED] nested if formula claims there are too many arguments
    By asthx in forum Excel General
    Replies: 3
    Last Post: 02-11-2013, 01:49 AM
  5. Need a Nested IF with 12 Arguments
    By daz_uk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-29-2010, 08:54 AM
  6. Going beyond 7 Nested If Arguments
    By Supdem in forum Excel General
    Replies: 2
    Last Post: 08-05-2009, 03:06 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