+ Reply to Thread
Results 1 to 5 of 5

Function only give allowed values

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    sweden
    MS-Off Ver
    Excel 2010
    Posts
    108

    Function only give allowed values

    Hi,

    I have a range with "allowed" values in a worksheet and a function that does some calculations for me.

    Lets say I have function

    Please Login or Register  to view this content.
    I would like the return of function to be rounded to closest value in my range of allowed values.

    My list of values in sheet2 cells A1:A300

    I hope I explained my case clear enough

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Function only give allowed values

    May be
    Please Login or Register  to view this content.
    As a formula
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    01-28-2013
    Location
    sweden
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Function only give allowed values

    Thank you for your quick reply. I will have to use INDEX function here as well to get the number I want?

  4. #4
    Forum Contributor
    Join Date
    01-28-2013
    Location
    sweden
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Function only give allowed values

    Worked nice with INDEX added. thanks for your help.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Function only give allowed values

    You are welcome. Glad I can offer some help
    Please put the code after adding Index ..
    Thanks advanced

+ 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. Replies: 2
    Last Post: 08-22-2015, 09:40 AM
  2. VBA Function to give multiple vlookup values
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-26-2015, 06:52 PM
  3. [SOLVED] Macro to give the count of unique values after comparing the comma separated values
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 12:41 AM
  4. Macro to check if in the cells are "allowed" values
    By forfiett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2012, 03:32 PM
  5. Replies: 2
    Last Post: 06-14-2010, 03:34 PM
  6. pls give me a function to do this
    By ukev22 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-14-2007, 04:17 AM
  7. Limit allowed values for cells
    By maMile in forum Excel General
    Replies: 3
    Last Post: 03-04-2007, 02:36 PM

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