Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP driving me crazy | Excel Discussion (Misc queries) | |||
basic...but driving me crazy! | Excel Discussion (Misc queries) | |||
My Shared workbook is driving me crazy!!! | Excel Discussion (Misc queries) | |||
Help: Scroll wheel toggles between up and down, and left and right - is driving me crazy | Excel Discussion (Misc queries) | |||
Date Comparison Driving Me Crazy | Excel Discussion (Misc queries) |