+ Reply to Thread
Results 1 to 2 of 2

Vlookup PREDETERMINED range and ROUNDING Help Plz

  1. #1
    Registered User
    Join Date
    10-01-2010
    Location
    Doncaster, England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Vlookup PREDETERMINED range and ROUNDING Help Plz

    Hi,

    I need to create a method of inputting 2 values (Min and Max) then using those values to lookup from a predetermined range of values to give me the desired output value possibly rounded (up or down dependant on the number) from the range.

    eg. Input value (Min) A=0.22
    Input value (Max) B=0.86

    Desired output value A=0.20 (Rounded Down)
    Desired output value B=0.88 (Rounded Up)

    The lookup range starts at 0.04 and increments up by 0.04, hence why the Output value A needs to be rounded down to the nearest 0.04 (this case 0.20) and Output value B is rounded up (to nearest 0.4 divisable) to 0.88.

    If the input values are divisible by lookup value then the output value would be the same as the input value.

    Just to complicate things further, the lookup range starts at 0.04 incrementing by this value up to 2.52.
    From 2.52 to 12.76 the increment is 0.16.
    And from 12.76 to 53.72 the increment is 0.64
    And from 53.72 to 199.64 the increment is 2.56.

    Many thanks to all for any assistance.

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

    Re: Vlookup PREDETERMINED range and ROUNDING Help Plz

    If we assume Input Value A is in A1 and Input Value B is in A2 then to get the revised values:

    Please Login or Register  to view this content.
    (you may wish to add pre-emptive tests to ensure inputs are within permitted boundaries)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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