Results 1 to 4 of 4

Finding a Variable Value with in multiple ranges

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2010
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Finding a Variable Value with in multiple ranges

    I have a table and I'm having the hardest time trying to find a function that will allow me to enter in a value and have it return the points listed. So for example if I type in .25 in a cell I would like it to return 100. or if I typed 1.30 it should return 250.

    I have tried VLookup but I obviously am not doing it correclty if that is the fuction that I need to use. Thanks for any help that I receive.

    Min Max Points
    0.00% 0.24% 50
    0.25% 0.49% 100
    0.50% 0.74% 150
    0.75% 1.24% 200
    1.25% 1.49% 250
    1.50% 2.49% 300
    2.50% 3.49% 340
    3.50% 4.49% 380
    4.50% 5.49% 420
    5.50% 6.49% 460
    6.50% 7.49% 500
    7.50% 8.49% 530
    8.50% 9.49% 560
    >9.50% 600
    Last edited by mikejohn11; 10-05-2010 at 12:56 AM.

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