ExcelBanter - Code for dividing amount amounts

Great

Thank you Jim

"Jim Thomlinson" wrote:

You need to use just 2 functions. Mod and Trunc. Here is houw you figure out
your 100s

=trunc(a1, -2)/100

noiw to find out what is left over after that

=mod(a1, 100)

Now you just need a bunch more of these to get to the 20s, 10s, 5s, ...

HTH

"Hill" wrote:

Greetings:
I am trying to design a sheet where the user will enter an amout; excel will
then divide that amount into 100s, 50s, 20s, 10s, 5s, 1s, and coins.

Does any know of a way (code or formulas) to achive this.

Thanks