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 <bpascal...@gmail.com> > *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/ <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
