I'm trying to come up with a cashier balance sheet, fairly simple. I
have everything done, except my manager would like me to add another
column for the cashier who cannot count down a till to a specific bank
amount. This is compounded by his insistence that the balance sheet
list each denomination of coin and bill. The bank amount is $250.00.
If the till is 386.41. broken down as follows I need a list of coins
and bills to keep to make the 250 bank and to make a deposit. How can
you evenly divide the $amount into each denomination and make it
balance? Thanks! Vern
EXAMPLE:
Amount in till For 250 Bank
For Deposit
PENNIES 0.56 0.55
0.01
NICKLES 1.50 1.45
0.05
DIMES 3.10 3.00
0.10
QUARTERS 4.25 4.00
0.25

ONES 32.00 30.00
2.00
FIVES 85.00 40.00
45.00
TENS 80.00 60.00
20.00
TWENTIES 180.00 100.00
80.00

TOTAL 386.41 250.00
147.41


--
JustVern69
------------------------------------------------------------------------
JustVern69's Profile: http://www.excelforum.com/member.php...o&userid=32464
View this thread: http://www.excelforum.com/showthread...hreadid=522474