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 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
