+ Reply to Thread
Results 1 to 4 of 4

Multiple IF/IFERROR statements, resulting in "too many arguments" error

Hybrid View

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Burlington, VT
    MS-Off Ver
    Office 365
    Posts
    8

    Multiple IF/IFERROR statements, resulting in "too many arguments" error

    Hello,

    I have a formula that works just fine now, but when I try to add another IF statement I get the "too many arguments" error. The working formula is:

    {=IF($D14="",SUMIF($A:$A,$B14&MID($C14,1,SEARCH(" Total",$C14,1)-1),F:F),IFERROR(ROUNDUP(INDEX(Forecast!$A:$J,MATCH(1,(comparison!$B14=Forecast!$A:$A)*(comparison!$D14=Forecast!$C:$C),0),F$1),0),"Not On Plan"))}

    the extra IF statement is: =IF($C20="",SUMIF($B:$B,LEFT($B20,LEN(B20)-6),F:F)/2)
    I tested this out alone and know if works.

    This is how I tried to combine them:
    {=IF($D4="",SUMIF($A:$A,$B4&MID($C4,1,SEARCH(" Total",$C4,1)-1),F:F),IFERROR(ROUNDUP(INDEX(Forecast!$A:$J,MATCH(1,(comparison!$B4=Forecast!$A:$A)*(comparison!$D4=Forecast!$C:$C),0),F$1),0)),IF($C20="",SUMIF($B:$B,LEFT($B20,LEN(B20)-6),F:F)/2),"Not On Plan")}

    Perhaps I am misplacing parentheses or something. Any help is appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,954

    Re: Multiple IF/IFERROR statements, resulting in "too many arguments" error

    Try

    =IF($D4="",SUMIF($A:$A,$B4&MID($C4,1,SEARCH(" Total",$C4,1)-1),F:F),IFERROR(ROUNDUP(INDEX(Forecast!$A:$J,MATCH(1,(comparison!$B4=Forecast!$A:$A)*(comparison!$D4=Forecast!$C:$C),0),F$1),0),IF($C20="",SUMIF($B:$B,LEFT($B20,LEN(B20)-6),F:F)/2,"Not On Plan")))

  3. #3
    Registered User
    Join Date
    11-17-2015
    Location
    Burlington, VT
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Multiple IF/IFERROR statements, resulting in "too many arguments" error

    Trying to edit my earlier post...

    Hi John,

    Thanks for taking the time to reply, but when I tried that the only answer I get is "0", which is incorrect.

    Also, I found an issue in my original formula. I think it should be closer to:

    =IF($D20="",SUMIF($A:$A,$B20&MID($C20,1,SEARCH(" Total",$C20,1)-1),F:F),IF($C20=$B20,(SUMIF($B:$B,LEFT($B20,LEN(B20)-6),F:F)/2),IFERROR(ROUNDUP(INDEX(Forecast!$A:$J,MATCH(1,(comparison!$B20=Forecast!$A:$A)*(comparison!$D20=Forecast!$C:$C),0),F$1),0),"Not On Plan")))

    Basically, I want to look at D20(UPC), and if it is blank sum up the product line values (i.e. Laundry Detergent). If D20 is blank AND C20=B20, then sum up the customer values and divide by 2. If neither of those IF statements is met, then the IFERROR statement should be returned.

    I think perhaps I need an AND statement or something. Unfortunately putting so many statements together is not yet a forte of mine!

    Thanks,
    Ashlie
    Last edited by agraham; 02-22-2016 at 09:59 AM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,954

    Re: Multiple IF/IFERROR statements, resulting in "too many arguments" error

    I cannot test it as it looks at sheets "Forecast" and "Comparison"

    Please post a sample file with required sheets.
    Last edited by JohnTopley; 02-22-2016 at 09:33 AM.

+ 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] Nested IF function error "You've entered too many arguments..."
    By lhendrickson in forum Excel General
    Replies: 15
    Last Post: 11-19-2018, 09:53 AM
  2. Revising an IF forumular, Error "too many arguments"
    By Clarkit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2015, 06:29 PM
  3. Getting "this function takes no arguments" and "#NAME?" error
    By chuckmckiel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2014, 01:58 PM
  4. Nested IF function error "You've entered too many arguments..."
    By lovetofly32 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2014, 08:33 PM
  5. If nested formulas, get "too many arguments" error
    By jpelayo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-13-2013, 05:40 AM
  6. Replies: 1
    Last Post: 06-07-2012, 11:38 AM
  7. Replies: 3
    Last Post: 09-07-2009, 04:48 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