# Formulae required to split the amount into different cash denomination

1. ## 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

Thanks

2. ## 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.

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

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. ## 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

Hi

Thanks

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

Originally Posted by Harrold
Hi

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

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

#### 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