I am brainstorming how to create an excel 2007 sheet that can calculate the optimum combination of change and cash for a cash drawer at a business' closing time. The excel sheet would allow the user to input the total amount of pennies, dimes, ones, twenties, etc. and excel would determine how to leave $400 in the drawer with the smallest denominations possible. For example if an employee ended the day with $945.45 in his or her till (aka drawer), this hypothetical excel sheet would remove $545.45 using as many $100’s, 50’s, 20’s, and quarters as possible and leaving denominations like pennies, 1’s, and 5’s.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
Does anyone where I would start for a project like this? Are there customizable add-ons that I could use to create this optimum cash drawer calculator? Would I have to use VBA? Please point me in the right direction. Thank you!
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o><o
></o>Does anyone where I would start for a project like this? Are there customizable add-ons that I could use to create this optimum cash drawer calculator? Would I have to use VBA? Please point me in the right direction. Thank you!
Last edited:
