# 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  Register To Reply

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.  Register To Reply

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)  Register To Reply

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  Register To Reply

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

Hi

Thanks  Register To Reply

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.  Register To Reply