HEEEEEEEEEELP!! This thing is driving me crazy.

[Guest]

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.

 

[Bob Phillips]

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)