+ Reply to Thread
Results 1 to 3 of 3

10 Arguments in a function

  1. #1
    Registered User
    Join Date
    04-28-2009
    Location
    Columbia, MO
    MS-Off Ver
    Excel 2003
    Posts
    6

    10 Arguments in a function

    I am looking for a way to take the weight input in cell "G2" and use it to calulate the below information:

    Less than 150 pounds = 20 Points
    150 to 174 pounds = 22 Points
    175 to 199 pounds = 24 Points
    200 to 224 pounds = 26 Points
    225 to 250 pounds = 28 Points
    250 to 275 pounds = 30 Points
    275 to 300 pounds = 31 Points
    300 to 325 pounds = 32 Points
    325 to 350 pounds = 33 Points
    Over 350 pounds = 34 Points

    And place it in cell "D20".

    I have been looking and I see that Excel only allows 7 arguments in an if statement. How would I go about putting all this into a function.

    To clarify:

    D20=G2<150 I need it to put 20 in the cell and so on for all of the above. Should this be an if statement at all?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: 10 Arguments in a function

    You can use LOOKUP (or VLOOKUP for this)

    =LOOKUP(G2,{0,150,175,200,225,250,275,300,325,350},{20,22,24,26,28,30,31,32,33,34})

  3. #3
    Registered User
    Join Date
    04-28-2009
    Location
    Columbia, MO
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: 10 Arguments in a function

    Oh man, I never thought of that... Thank you 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