+ Reply to Thread
Results 1 to 3 of 3

Automatic dividing of a changing number

  1. #1
    Registered User
    Join Date
    12-30-2014
    Location
    Belgium
    MS-Off Ver
    2010
    Posts
    1

    Automatic dividing of a changing number

    Hello,

    I have a changing number in excel, at the moment this number is 1800, and right now this number can be divided by 600 so that the sollution is 3. But what if that number changes to say 2100, the sollution for the division '/600' will be different and will be a number with more digits after a comma, which is something I want to avoid. To get an even number the division would have to change to say 525, to get "4" as the sollution.
    Is there a formula or another way to make excel determine by what number to divide to get a sollution that is between 3-6 and has no commas? Ideally this would happen automatically when the number in the cell changes.

    I hope I made sense. Thanks in advance!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Automatic dividing of a changing number

    Could you use ROUND to round the answer to the nearest whole number?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,343

    Re: Automatic dividing of a changing number

    There might be more sophisticated algorithms out there, but, with only 4 possible solutions, I would probably set up a simple trial and error approach. First, some algebra:

    The problem statement, if I understand it correctly, is Given a, we want to divide a by some number b that will give us an integer c between 3 and 6. So, c=a/b. Since b is the number we want to find, rearrange to solve for b b=a/c. Then set up the spreadsheet to compute the four possible divisors and determine which ones are integers. Those will be my possible solutions.

    Example: 1800/3=600, 1800/4=450, 1800/5=360, 1800/6=300. Possible divisors are 600, 450, 360, 300. I'm not sure at this point how you will choose which one.
    example: 2100/3=700, 2100/4=525, 2100/5=420, 2100/6=350. Possible divisors are 700, 525, 420, 350. I'm not sure how you will choose which one.

+ 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. [SOLVED] Dividing a number
    By tutman4k in forum Excel General
    Replies: 8
    Last Post: 12-05-2014, 05:29 AM
  2. Dividing an odd number into three.
    By haylleyjo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2013, 09:14 AM
  3. Replies: 2
    Last Post: 05-09-2011, 10:11 AM
  4. Automatic "Bold" or color changing a number?
    By rajivvyas in forum Excel General
    Replies: 4
    Last Post: 08-14-2007, 11:53 AM
  5. Dividing by unknown to get a number
    By bundyloco in forum Excel Formulas & Functions
    Replies: 59
    Last Post: 09-06-2005, 07:05 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