+ Reply to Thread
Results 1 to 9 of 9

Dividing a number

  1. 12-05-2014, 04:46 AM #1
    tutman4k is offline
    Registered User
    Join Date
    06-26-2014
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    21

    Dividing a number

    Hello everyone,

    I have a list of numbers and I wanted the number to be divided. The division is tricky as the number must be divided first by 50 then 25, 10 and 5.
    For example: the number is 90. So I can get 1 of 50, 1 of 25, 1 of 10 and 1 of 5. If the number is 95, I can get 1 of 50, 1 of 25, and 2 of 10.

    I hope this explains what I am looking for.

    I am grateful for all the help I can get from you.

    Cheers,

    T
    Reply With QuoteRegister To Reply
  2. 12-05-2014, 04:51 AM #2
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: Dividing a number

    Attach sample file with enough examples
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 12-05-2014, 04:59 AM #3
    AlanY is offline
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    Re: Dividing a number

    is that what you're after?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-05-2014, 05:04 AM #4
    pjwhitfield is offline
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Dividing a number

    I cant see this as being possible without a Function....


    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation
    Reply With QuoteRegister To Reply
  5. 12-05-2014, 05:06 AM #5
    tutman4k is offline
    Registered User
    Join Date
    06-26-2014
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Dividing a number

    Capture.JPG

    I hope this helps
    Attached Files Attached Files
    Last edited by tutman4k; 12-05-2014 at 05:11 AM. Reason: Better Look
    Reply With QuoteRegister To Reply
  6. 12-05-2014, 05:11 AM #6
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Dividing a number

    here is the formula for tricky division
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    check the attached file
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  7. 12-05-2014, 05:14 AM #7
    tutman4k is offline
    Registered User
    Join Date
    06-26-2014
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Dividing a number

    Thank you pjwhitfield, but I am unable to paste this code. Since I am a beginner, could you please tell me how to use this code?
    Reply With QuoteRegister To Reply
  8. 12-05-2014, 05:15 AM #8
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Dividing a number

    >> I hope this explains what I am looking for.

    I'm afraid it doesn't. It looks like you don't want to divide a number but work out how many multiples of a list of values make up the number. Is that correct?

    Try this approach with helper columns

    A
    B
    C
    D
    E
    F
    G
    H
    I
    1
    		 helper columns how many
    2
    		 number
    50
    25
    10
    5
    50
    25
    10
    5
    3
    95
    45
    20
    0
    0
    1
    1
    2
    0
    4
    90
    40
    15
    5
    0
    1
    1
    1
    1


    The formula in cell B3 is

    Please Login or Register  to view this content.
    Copy across to E3. Then copy down.

    The formula in cell F3 is

    Please Login or Register  to view this content.
    Copy across to I3. Then copy down.

    If that does not help, post a sample file and mock up your expected results manually, so we can see what you would like to achieve.
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
  9. 12-05-2014, 05:29 AM #9
    tutman4k is offline
    Registered User
    Join Date
    06-26-2014
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    21

    Re: Dividing a number

    Dear everyone,

    Thank you all for the help. Teylyn your method did work and I am very thankful to all the excel experts who helped me out. Vikas, I was unable to use your formula as i kept getting Div0 error.
    All help is appreciated. Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dividing an odd number into three.
    By haylleyjo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2013, 09:14 AM
  2. Dividing a total using % but need whole number answers
    By dhunt in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-28-2012, 12:41 PM
  3. Dividing only the most recently entered number by the initial number.
    By jonvanwyk in forum Excel General
    Replies: 2
    Last Post: 05-09-2011, 10:11 AM
  4. dividing by number of cells
    By DevonDuggan13 in forum Excel General
    Replies: 1
    Last Post: 06-25-2010, 01:12 PM
  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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1