Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split a cash amount into two separate cash amounts
I'm trying to find a way for excel 2000 (win 2000), perhaps with the
assistance of vba, to split a cash amount into two separate cash amounts. The total is the cash drawer (the till). The two sub totals are the takings and the float. The user will enter the number of coins and notes of each denomination. The float must contain most, if not all, of the 5c, 10c, 20, 50c, $1 & $2 coins the $5, $10 and possibly the $20 notes. The takings will contain all the $100, all or most of the $50, the appropriate number of $20, $10, $5, $2, $1, 50c, 20c, 10c, 5c. This, to me, is a diabolically complex issue and I've tried many different approaches over the last six months, but it's really too hard for me to work it out. Perhaps someone has done this before and can help? If so, I'd be very grateful. Regards, David Lindstrom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
split a cash amount into two separate cash amounts
Presumably the float is a fixed amount set up in advance of the 'days
trading' if it is then why does the Total - Float not yield the Takings total ? If the user enters a value for the quantity of each coin or note denomination, then simply producing intermediate sub totals using value of note(or coin) * quantity. Add all these sub totals up and you will have the Total in the till. If you want to know the 'make up' of each in terms of the individual coins and notes then apart for the obvious $50 & $100 bills (and possibly the $20 if not in float at start), you cannot in all but exceptional circumtances. "tegger" wrote in message ... I'm trying to find a way for excel 2000 (win 2000), perhaps with the assistance of vba, to split a cash amount into two separate cash amounts. The total is the cash drawer (the till). The two sub totals are the takings and the float. The user will enter the number of coins and notes of each denomination. The float must contain most, if not all, of the 5c, 10c, 20, 50c, $1 & $2 coins the $5, $10 and possibly the $20 notes. The takings will contain all the $100, all or most of the $50, the appropriate number of $20, $10, $5, $2, $1, 50c, 20c, 10c, 5c. This, to me, is a diabolically complex issue and I've tried many different approaches over the last six months, but it's really too hard for me to work it out. Perhaps someone has done this before and can help? If so, I'd be very grateful. Regards, David Lindstrom ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
split a cash amount into two separate cash amounts
You don't give any rules for determining "most, if not all", "all or most",
and "appropriate number". unless you can define these rules/your objective, the problem will remain diabolically complex. -- Regards, Tom Ogilvy tegger wrote in message ... I'm trying to find a way for excel 2000 (win 2000), perhaps with the assistance of vba, to split a cash amount into two separate cash amounts. The total is the cash drawer (the till). The two sub totals are the takings and the float. The user will enter the number of coins and notes of each denomination. The float must contain most, if not all, of the 5c, 10c, 20, 50c, $1 & $2 coins the $5, $10 and possibly the $20 notes. The takings will contain all the $100, all or most of the $50, the appropriate number of $20, $10, $5, $2, $1, 50c, 20c, 10c, 5c. This, to me, is a diabolically complex issue and I've tried many different approaches over the last six months, but it's really too hard for me to work it out. Perhaps someone has done this before and can help? If so, I'd be very grateful. Regards, David Lindstrom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for cash on cash payback | Excel Discussion (Misc queries) | |||
Why do I get #### signs when entering cash amount in account mode | Excel Discussion (Misc queries) | |||
Keeping my cash expenses from subtracting the cash balance | New Users to Excel | |||
Financial Calc: present cash value of a future amount | Excel Worksheet Functions | |||
cash denominations split up | Excel Discussion (Misc queries) |