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
|