+ Reply to Thread
Results 1 to 12 of 12

Too many arguments

  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Too many arguments

    Trying to add an argument to an already working formula - see attached worksheet w/the formula/cell in question in yellow.

    I need to add the following logic to the existing formula,

    If L10="N", AND O30<L9, then O30-L9, otherwise, if L10="", then O31-L9.

    I have tried AND, but I'm not entering something correctly.

    Any guidance would be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Too many arguments

    Try this untested formula

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


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Too many arguments

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


    Sorry Sixthsense, i happened to post at the same time as you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Too many arguments

    Quote Originally Posted by arlu1201 View Post
    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Sorry Sixthsense, i happened to post at the same time as you.
    It happened many time to me also. We are not intended to do it, but it happens when the method is same. No problem and we know about your excel knowledge

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Too many arguments

    Thanks for understanding.

  6. #6
    Registered User
    Join Date
    12-29-2010
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Too many arguments

    Thank you both - I tried to add your suggested formula to the existing formula but I still get "too many arguments".

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Too many arguments

    Quote Originally Posted by smcduffi View Post
    Thank you both - I tried to add your suggested formula to the existing formula but I still get "too many arguments".
    Can you please share your existing formula with us, so that it will be helpful to trace the error.

  8. #8
    Registered User
    Join Date
    12-29-2010
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Too many arguments

    I'm sorry - are you unable to view the formula in the file i attached? If not, it's =IF(OR($L$6="Deltacare",$L$6="Cigna DHI"),"",IF(O31<L9,"",O31-L9))
    The cell is highlighted in yellow.

  9. #9
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Too many arguments

    It's not 100% clear how you want to fit these new arguments in with the existing formula but perhaps this.

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

  10. #10
    Registered User
    Join Date
    12-29-2010
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Too many arguments

    Thank you - hmmm...still not working. I'll try to better explain what I need this cell to show.

    It(P36) should be Blank if L6= Deltacare or CignaDHI - regardless.
    If L6 is anything but those two, it should determine if L10 = N (this is the new variable I'm adding to the formula)
    If L10=N, then it should determine if O30 is greater than L9, if yes, then the value should be O30-L9, if no, then the value should be blank
    If L10="", then it should determine if O31 is greater than L9, if yes, then the value should be O31-L9, if no, then the value should be blank

    I hope that helps. Thanks so much for your efforts!

  11. #11
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Too many arguments

    Here's another try.

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

  12. #12
    Registered User
    Join Date
    12-29-2010
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Too many arguments

    Perfect - had to fix a couple of typos but the logic works! Thank you so so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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