| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
| Need VBA Code/Marcos To Hide Less than zero amounts. Not a filter | Excel Worksheet Functions | |||
| Count amount of different dates & amounts of them. | New Users to Excel | |||
| Formatting monetary amounts with currency indicator on extreme left and amount right ? | Excel Discussion (Misc queries) | |||
| split a cash amount into two separate cash amounts | Excel Programming | |||
Linear Mode
