HEEEEEEEEEELP!! This thing is driving me crazy.
 

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.

HEEEEEEEEEELP!! This thing is driving me crazy.
 

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)

"Esaam" wrote in message
...
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.