+ Reply to Thread
Results 1 to 6 of 6

Formulae required to split the amount into different cash denomination

  1. #1
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    74

    Formulae required to split the amount into different cash denomination

    Hi

    For some reason, i am unable to attached a file. Hence, i will show my example here.

    The amount is $1256,

    Cash Denomination will be $500, $100, $50,$10,$5 and $1. I need to split the amount into the number of pieces of each domination to present to the bank when i need to withdraw salary for the workshop workers.

    500 100 50 10 5 1
    1256 2 2 1 0 1 1

    Can someone please assist me?

    Thanks

  2. #2
    Registered User
    Join Date
    03-24-2011
    Location
    Bristol
    MS-Off Ver
    Excel 2000
    Posts
    36

    Re: Formulae required to split the amount into different cash denomination

    divide the amount by 500 and take its integer this will be the number of $500 you will need.
    next subtract from the initial amount 500 multiplied by the previous answer.

    Take this new amount and divide by 100 and take the integer...and so on.

    If this is your weekly payroll...can I have a job please..haha.

  3. #3
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Excel 2019
    Posts
    447

    Re: Formulae required to split the amount into different cash denomination

    Assume your value in A1
    then B1 = =INT(A1/1000)*1000
    C1=(INT((A1-B1)/100)*100)
    d1 =(INT((A1-B1-C1)/50)*50)
    e1 =(INT((A1-B1-C1-D1)/10)*10)
    f1 =(INT((A1-B1-C1-D1-E1)/5)*5)
    g1 =A1-SUM(B1:F1)

  4. #4
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    74

    Re: Formulae required to split the amount into different cash denomination

    Hi

    @Col12345, I tried to use your way, but my English is poor so i am not totally grasp the formula. Is it possible for you to provide me with the formulae? Thanks

    @Sadath31, I tried yours also, but the result is full amount instead of number of pieces. Is it okay to amend the formula as i dont know how to correct it? Thanks

  5. #5
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    74

    Re: Formulae required to split the amount into different cash denomination

    Hi

    Please assist.

    Thanks

  6. #6
    Registered User
    Join Date
    07-31-2012
    Location
    Buffalo, United States
    MS-Off Ver
    MS Office 2007, 2010, 2013
    Posts
    59

    Re: Formulae required to split the amount into different cash denomination

    Quote Originally Posted by Harrold View Post
    Hi

    Please assist.

    Thanks
    Use Sadath31 formula, and on another cell use that full amount divide by the cash denomination you want.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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