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 1.00 0.50 0.20 0.10 0.05 0.02 0.01
40.00 20.00 5.00 1.00
14 2 1 4 1 1 1 0 2 0 309.84
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 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 intermediate formula and I try
to avoid "jumbo" ifs formula dfficult to understand and evaluate). Here offset,
row, mod and even unitary formula... and a few logic with some arithmetic would
seem most appropriate to me.
If you feel comfortable with this, you can find a workbook attached. There is
the official solution below mine, but I don't get exactly to the same numbers.
And I checked both are consistent and coherent. So maybe your solution will
tell if I'm wrong or not and why don't I get to the same numbers.
Quickly, the instruction is:
To reach a given total, you must use at least 2 notes of 20, 2 notes of 10, 1
note of 5 and 1 note of 1 and any decimal number specified in the header row.
Feel free to show your skills!
By the way, you did a great job with this group Ayush, thanks.
Pascal Baro
http://multiskills.elementfx.com/
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
