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
$$ Cash allocation - your advice
Hi Cyberspace,
Please find a workbook with something I did I'm not satisfied with. It does the
job but something better can be done and to be honest it's beyond my present
knowledge of Excel.
What I see is only 1 formula (my solution uses intermedia
gt;
> *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 workbook with something I did I'm not satisfied with. It
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
