Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If I enter S35 ...
The main notes ... are $1,$2,$5,$10 and $20. As a side note, an interesting programming problem is determining there are 162 possible solutions. (although we know you meant the minimum number of denominations) (Throw in pennies, nickles, dimes, and quarters, and there are 471,281,825 :) = = = = = = = Dana DeLouis On 2/8/10 1:25 AM, ekkeindoha wrote: Good day, I would like to teach kids on money.Is there a formula that wil do the following. If I enter S35 it should give me a feedback of 1 x $20 , 1 X $10 and 1 X $5 The main notes to be used are $1,$2,$5,$10 and $20. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to deploy xls with config based conn str (Dev vs Test vs Prod) | Excel Discussion (Misc queries) | |||
Config Now() troubles | Excel Worksheet Functions |