Re: $$Excel-Macros$$ Cash allocation - your advice

2012-03-24 Thread bpascal123
At first, you need to put aside 66 since you must use 2 bills (or notes) of $20, 2 bills of $10, 1 bill of $5 and 1 for $1. All the required notes make $66. Then you can make any adjustment with the 50c, 20c, 10c, 5c, 2c and 1c. People who like binary counting and all that stuff should be fine

Re: $$Excel-Macros$$ Cash allocation - your advice

2012-03-24 Thread dguillett1
Are you saying that you start with the final amount, ie 309.84 then use the required values @ 66 to find the amount of each various amount needed to get to the difference to come up with (bottom row shown here) 66 20 10 5 1 50p 20p 10p 5p 2p 1p total 20.00 10.00 5.00

Re: $$Excel-Macros$$ Cash allocation - your advice

2012-03-24 Thread bpascal123
nope, professional training, I found my own answer so it's just extra On Saturday, March 24, 2012 1:43:07 PM UTC, Don Guillett wrote: > > Makes me wonder what this is for. Homework? > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Pascal Baro

Re: $$Excel-Macros$$ Cash allocation - your advice

2012-03-24 Thread dguillett1
Makes me wonder what this is for. Homework? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Pascal Baro Sent: Friday, March 23, 2012 8:19 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Cash allocation - your advice Hi Cyberspace, Please find a wo