Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |