software

Here's a brain tickler. I have a counting aid for cash. All ihave to do is
input the number of each. It adds/subtracts the cash just fine. Here's the
kicker: I want it to break it down using the maximum denomination first. So
say my cash on hand is 950, then I have to subtract 150 because of my drawer.
That's 800, so now, how would I get it to tell me how to break down my cash
using the maximum number of the larger denominations first. Like it would
tell me to pull:
1-$100
3-$50
20-$20
10-$10
4-$5
10-$2
-$1-10

Any help would be much appreciated.


Here is one way

Assuming that value is to break down is in A1.

First enter the bill denominations in B1:B7
B1: 100
B2: 50
B3: 20
B4: 10
B5: 5
B6: 2
B7: 1

Then in C1 and C2 enter these formulae,

C1: =INT($A$1/B1)
C2: =INT(($A$1-SUMPRODUCT($B$1:B1,$C$1:C1))/B2)

copy C2 down to c7

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Esaamquot; gt; wrote in message
...
gt; Here's a brain tickler. I have a counting aid for cash. All ihave to do is
gt; input the number of each. It adds/subtracts the cash just fine. Here's
the
gt; kicker: I want it to break it down using the maximum denomination first.
So
gt; say my cash on hand is 950, then I have to subtract 150 because of my
drawer.
gt; That's 800, so now, how would I get it to tell me how to break down my
cash
gt; using the maximum number of the larger denominations first. Like it would
gt; tell me to pull:
gt; 1-$100
gt; 3-$50
gt; 20-$20
gt; 10-$10
gt; 4-$5
gt; 10-$2
gt; -$1-10
gt;
gt; Any help would be much appreciated.