+ Reply to Thread
Results 1 to 14 of 14

You've entered to many arguments for this function????????

  1. 01-18-2014, 01:15 PM #1
    STU22
    STU22 is offline
    Forum Contributor
    Join Date
    10-26-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    133

    You've entered to many arguments for this function????????

    I cant figure out why this is giving me a message of you've entered to many arguments for this function. I think its my parenthsies but im not sure. Can anyone help please. Thanks

    =ROUND(IF(AND(E28="No",B43=1),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*4+0.1575)/2,IF(AND(E28="No",B43=1),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*4+0.1575)/2))*16,0)/16
    Reply With QuoteRegister To Reply
  2. 01-18-2014, 01:24 PM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: You've entered to many arguments for this function????????

    =ROUND(IF(AND(E28="No",B43=1),E29-F11*2+0.0787,IF(AND(E28="No",B43=1),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*4+0.1575)/2))*16,0)/16
    is how it would be written BUT

    AND(E28="No",B43=1) is the same in both IFS


    =if(and(thing1,thing2),do something,if(and(thing3,thing4),"do something else","what to do if both the ifs are false"))
    Last edited by martindwilson; 01-18-2014 at 01:29 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 01-18-2014, 01:26 PM #3
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: You've entered to many arguments for this function????????

    I *think* you've duplicated your IF function.
    Try this:
    Please Login or Register  to view this content.
    Is that what you want?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  4. 01-18-2014, 01:26 PM #4
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: You've entered to many arguments for this function????????

    You have more than 3 arguments of IF statement, maybe this works:
    =ROUND(IF(AND(E28="No",B43=1),E29-F11*2+0.0787,((E23-E41-E42-E43-F11*4+0.1575)/2)*16),0)/16
    Quang PT
    Reply With QuoteRegister To Reply
  5. 01-18-2014, 03:32 PM #5
    STU22
    STU22 is offline
    Forum Contributor
    Join Date
    10-26-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    133

    Re: You've entered to many arguments for this function????????

    Thanks for the reply's. Below is the entire formula, how would this be structured? Thanks


    =ROUND(IF(AND(E28="No",B43=1),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*4+0.1575)/2,IF(AND(E28="No",B43=2),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*6+0.2362)/3,IF(AND(E28="No",B43=3),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*8+0.3150)/4,IF(AND(E28="No",B43=4),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*10+0.3937)/5,IF(AND(E28="No",B43=5),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*10+0..3937)/5)*16,0)/16
    Reply With QuoteRegister To Reply
  6. 01-18-2014, 04:11 PM #6
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: You've entered to many arguments for this function????????

    you cant have 3 results from an IF
    IF(AND(E28="No",B43=1),E29-F11*2+0.0787,(E23-E41-E42-E43-F11*4+0.1575)/2,IF(.............
    what do you want to happen if
    IF(AND(E28="No",B43=1) evaluates to true
    Reply With QuoteRegister To Reply
  7. 01-18-2014, 04:27 PM #7
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: You've entered to many arguments for this function????????

    I'm just taking a SWAG here...
    Is this what you're trying to do?
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 01-18-2014, 05:01 PM #8
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: You've entered to many arguments for this function????????

    Here is my 2 cents worth.....a real guess. I think that you have the TRUE and FALSE parts of the If statements reversed but I can't tell because I don't know what you are calculating and what to expect.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  9. 01-18-2014, 05:13 PM #9
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: You've entered to many arguments for this function????????

    That was my thought, too, @newdoverman
    The formula I posted is my attempt at abbreviating the formula.
    We'll see if we guessed right
    Reply With QuoteRegister To Reply
  10. 01-18-2014, 05:29 PM #10
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: You've entered to many arguments for this function????????

    @ Ron Coderre
    I'm not putting any money on it....LOL...I had nothing better to do at the moment.
    Reply With QuoteRegister To Reply
  11. 01-18-2014, 08:37 PM #11
    STU22
    STU22 is offline
    Forum Contributor
    Join Date
    10-26-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    133

    Re: You've entered to many arguments for this function????????

    Guys thanks for the replys.

    Ron I would like to simplify the formula, but not sure I understand the formula that you posted. I understand the 1st part up to the /Min then Im lost.

    I got it to work like I wanted with this.

    Please Login or Register  to view this content.
    Thanks For the Reply's
    Reply With QuoteRegister To Reply
  12. 01-18-2014, 09:16 PM #12
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: You've entered to many arguments for this function????????

    Here's the abbreviated version of the formula you posted:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  13. 01-19-2014, 07:53 AM #13
    STU22
    STU22 is offline
    Forum Contributor
    Join Date
    10-26-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    133

    Re: You've entered to many arguments for this function????????

    Thanks Ron, I will give it a try
    Reply With QuoteRegister To Reply
  14. 01-20-2014, 06:40 PM #14
    DaleJrFan88
    DaleJrFan88 is offline
    Registered User
    Join Date
    05-21-2012
    Location
    Monterey, California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: You've entered to many arguments for this function????????

    Is there a way to simplify the following formula (highlighted):

    =IF(OR('Payroll detail report'!E2="REGLAR",HOURLYSW2PI!D2=0),'Payroll detail report'!G2,IF(AND('Payroll detail report'!E2="GRAVE1",HOURLYSW2PI!D2>0),'Payroll detail report'!G2,IF(AND('Payroll detail report'!E2="GRAVE2",HOURLYSW2PI!D2>0),'Payroll detail report'!G2,IF(AND('Payroll detail report'!E2="GRAVE3",HOURLYSW2PI!D2>0),'Payroll detail report'!G2,IF(AND('Payroll detail report'!E2="SCHED",HOURLYSW2PI!D2>0),'Payroll detail report'!G2,IF(AND('Payroll detail report'!E2="LEAD",HOURLYSW2PI!D2>0),'Payroll detail report'!G2,IF(AND('Payroll detail report'!E2="OPI",HOURLYSW2PI!D2>0),'Payroll detail report'!G2,""))))
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Entered to many arguments for this function
    By cuda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2014, 01:33 PM
  2. You've entered too many arguments for this function. Error
    By MacAaroni74 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-02-2013, 09:06 PM
  3. [SOLVED] [IF/AND] You've entered too many arguments for this function.
    By seaspi in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-21-2013, 07:04 PM
  4. You've entered too many arguments for this function
    By sutharnehal in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-24-2012, 09:25 PM
  5. You've entered too many arguments for this function
    By leematthews in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-21-2011, 03:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1