+ Reply to Thread
Results 1 to 13 of 13

Too Many Arguments for This Function.

  1. #1
    Registered User
    Join Date
    09-21-2013
    Location
    PA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Too Many Arguments for This Function.

    Hi-

    I am new to excel functions (if, or, and, etc). I am trying to create a function that has the following statements embedded in one function:

    if x and 1st=96
    if x and 2nd=25
    if no x and 1st=25
    if no x and 2nd=0

    I tried to used the formula below, but I have received the error message that the fuction has too many arguments.
    =IF(AND(D13="x", $F$11="1st"), 96, (AND(D13="x", $F$11="2nd")), 25,OR(IF(AND(D13=" ", $F$11="1st"))), 25, (AND(D13=" ", $F$11="2nd"), 0))

    Any assistance is much appreciated.

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: Too Many Arguments for This Function.

    Hi Sander,

    Always place the next if statement at the end of the current one you have. I think this is what tou need but the OR function there is throwing me off a little, I think its not needed.

    Here is the formula I think is what you need.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Thanks
    Last edited by fredlo2010; 09-21-2013 at 11:00 PM.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Too Many Arguments for This Function.

    Here is a tutorial on nested if statements.

    http://www.techonthenet.com/excel/fo.../if_nested.php
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Too Many Arguments for This Function.

    Hi and welcome to the forum

    This variation may also work for you...
    =if(D13="X",If($F$11="1st",96,If($F$11="2nd",25),0),If($F$11="1st",25,If($F$11="1st",25,0)))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Too Many Arguments for This Function.

    Quote Originally Posted by FDibbins View Post
    Hi and welcome to the forum

    This variation may also work for you...
    =if(D13="X",If($F$11="1st",96,If($F$11="2nd",25),0),If($F$11="1st",25,If($F$11="1st",25,0)))
    Your formula does not work. Check your syntax error

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Too Many Arguments for This Function.

    Quote Originally Posted by Teethless mama View Post
    Your formula does not work. Check your syntax error
    What a nice and courteous post !

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Too Many Arguments for This Function.

    Quote Originally Posted by Teethless mama View Post
    Your formula does not work. Check your syntax error
    So offer something constructive of your own?

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Too Many Arguments for This Function.

    Hi ,

    Try this formula:

    =IF(D13="X",IF($F$11="1st",96,IF($F$11="2nd",25)),IF($F$11="1st",25,IF($F$11="1st",25)))

    See the attached workbook to test the formula above. One test is ALWAYS worth a thousand opinions....
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Too Many Arguments for This Function.

    or...
    =if(D13="X",If($F$11="1st",96,If($F$11="2nd",25,0)),If($F$11="1st",25,If($F$11="1st",25,0)))

  10. #10
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Too Many Arguments for This Function.

    I agree that this second suggestion worked..

    Here are your two suggestions.. The first gives a syntax error and the second one works.

    =if(D13="X",If($F$11="1st",96,If($F$11="2nd",25),0),If($F$11="1st",25,If($F$11="1st",25,0)))
    =if(D13="X",If($F$11="1st",96,If($F$11="2nd",25,0)),If($F$11="1st",25,If($F$11="1st",25,0)))

    They are very, very close to being the same...

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Too Many Arguments for This Function.

    Yes, I closed the ) too soon in the 3rd IF() statement

  12. #12
    Registered User
    Join Date
    09-21-2013
    Location
    PA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Too Many Arguments for This Function.

    This worked! Thanks!

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Too Many Arguments for This Function.

    you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 at the bottom of my FIRST post to this thread)

+ 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. IF Function - Too Many Arguments
    By svconners in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-05-2013, 05:06 PM
  2. [SOLVED] IF Function - Too Many Arguments
    By djrazorback in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2013, 08:27 PM
  3. Too few arguments for this function
    By clovelly in forum Excel General
    Replies: 6
    Last Post: 10-22-2012, 07:40 PM
  4. sum :Too many arguments for this function
    By eparsons in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2007, 01:05 PM
  5. Replies: 0
    Last Post: 06-20-2006, 10:55 AM

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