+ Reply to Thread
Results 1 to 5 of 5

Contains too many arguments

  1. #1
    Registered User
    Join Date
    12-30-2016
    Location
    Hickory NC
    MS-Off Ver
    2013
    Posts
    2

    Contains too many arguments

    I have a formula a have not figured out a way to shrink down to operable levels.. can anyone assist me? I know it looks very daunting but the equation its self is simple I just cant figure out a way to condense it.

    =IF(H9<100%,IF(F8<85%,0,IF(F8<90%,50%,IF(F8<100%,75%,IF(F8<115%,F8,IF(F8<125%,110%,IF(F8<175%,125%,IF(F8>=175%,125%))))))),IF(H9<110%,IF(F8<85%,0,If(f8<89.9%,75%,If(f8<99.9%,75%,If(f8<114.9%,F8,If(f8<124.9%,125%,If(f8<149.9%,150%,If(f8<174.9%,175%,If(f8>=175%,F8,))))))))),If(h9>=110%,If(f8<84.9%,0%,If(f8<89.9%,75%,If(f8<99.9%,75%,If(f8<114.9%,F8,If(f8<124.9%,135%,If(f8<149.9%,160%,If(f8<174.9%,185%,If(f8>=175%,F8,))))))))))

    The formula will function until the last " If(h9>110%

    Thanks a ton!!

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Contains too many arguments

    Welcome to the board.

    Maybe this:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,851

    Re: Contains too many arguments

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  4. #4
    Registered User
    Join Date
    12-30-2016
    Location
    Hickory NC
    MS-Off Ver
    2013
    Posts
    2

    Re: Contains too many arguments

    Thank you so much for the input. im at work now and in between checking the thread I created a working version as follows..

    =IF(H9<100%,IF(F8<85%,0,IF(F8<90%,50%,IF(F8<100%,75%,IF(F8<115%,H9,IF(F8<125%,110%,IF(F8<175%,125%,IF(F8>=175%,125%))))))),IF(H9<110%,IF(F8<85%,0,IF(F8<89.9%,75%,IF(F8<99.9%,75%,IF(F8<114.9%,H9,IF(F8<124.9%,125%,IF(F8<149.9%,150%,IF(F8<174.9%,175%,IF(F8>=175%,H9,)))))))),IF(F8<84.9%,0%,IF(F8<89.9%,75%,IF(F8<99.9%,75%,IF(F8<114.9%,H9,IF(F8<124.9%,135%,IF(F8<149.9%,160%,IF(F8<174.9%,185%,IF(F8>=175%,H9,))))))))))

    but thank you so much for the assistance! as I'm not the most fluid with excel anymore I know my formula is much more bulky but its getting the job done! haha

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Contains too many arguments

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Too many arguments
    By azbi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-23-2016, 02:42 AM
  2. too many arguments
    By HPIMICHAEL02 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2016, 01:59 PM
  3. [SOLVED] Too many arguments?
    By Jamie2468 in forum Excel General
    Replies: 4
    Last Post: 08-25-2015, 08:12 PM
  4. [SOLVED] Too many arguments
    By smcduffi in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-05-2012, 01:09 PM
  5. IF and AND too many arguments
    By andrea_davis09@yahoo in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-27-2012, 05:56 PM
  6. Too few arguments
    By Chris225 in forum Excel General
    Replies: 10
    Last Post: 04-28-2011, 10:11 AM
  7. Too many arguments!
    By furiousboy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-15-2008, 01:37 PM

Tags for this Thread

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