+ Reply to Thread
Results 1 to 7 of 7

find closest number

  1. #1
    Registered User
    Join Date
    01-01-2014
    Location
    iran
    MS-Off Ver
    Excel 2013
    Posts
    19

    Lightbulb find closest number

    hi
    i have 2 numbers for example 2000 and 300.The number of 2000 to 300 is not divisible.how find The closest number to 300 is divisible by 2000.
    tanx

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: find closest number

    Please Login or Register  to view this content.
    or maybe your English is round the wrong way as this is an surprising example. in which case

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

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

    Re: find closest number

    Do you mean something like that
    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

  4. #4
    Registered User
    Join Date
    01-01-2014
    Location
    iran
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: find closest number

    sorry
    I could not understand what I meant.
    When we divide the number of 2000 by 300,answer is not integer.(2000/300=6.66667).I want to replace the number 300, which can be divided into 2000 And the nearest number is 300.in this example,number 250 is answer( 2000/250=8)

  5. #5
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: find closest number

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  6. #6
    Registered User
    Join Date
    01-01-2014
    Location
    iran
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: find closest number

    Quote Originally Posted by karedog View Post
    Maybe :
    Please Login or Register  to view this content.
    tanx a lot

  7. #7
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: find closest number

    You are welcome.

    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. How to find the closest number in range
    By mariab1 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-11-2015, 10:52 AM
  2. Find Highest or Closest number from list
    By ChrisKustom in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 08-10-2013, 08:41 AM
  3. Find the closest number
    By xyba in forum Excel General
    Replies: 9
    Last Post: 10-21-2010, 04:20 AM
  4. find closest date (number) in a range
    By wamp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2010, 01:50 PM
  5. Find Number Closest to Zero
    By snapa in forum Excel General
    Replies: 2
    Last Post: 12-04-2009, 05:34 PM
  6. Find the closest match to a reference number in a row of unsorted
    By Nick Krill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-01-2006, 04:35 PM
  7. Replies: 4
    Last Post: 12-21-2005, 08:00 AM

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