Code for dividing amount amounts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thank you Jim

Jim Thomlinson said:
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
Click to expand...
 
Back
Top