Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Okay...I never thought I would ever have to use excel again. Lo and behold, I
am now the owner of a business and have forgotten how to do some things. I know how to create formaulas for adding and stuff. I forgot how to make my calculatons so that my deposit would be broken down. For example say I have 5 of each dollar denomination (1,2,5,10,20,50,100) and coin (1,5,10,25,50,$1). My deposit has to be 790 (5 of each denomination-150). What I want my sheet to do is tell me how much of each denomination I should pull out in terms of numbers instead of dollar amount. For exaple instead of telling me to pull $790 I want it to tell me to pull 5-$100 bills 5-$50 bills and 4-10 bills. Basically breaking down my cash with the largest possible denomination until there can be no more. Any help would be deeply appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Sum Product Question | Excel Worksheet Functions | |||
Sum and Count are driving me nuts!! | Charts and Charting in Excel | |||
Driving me nuts. Need more nested than 7 | Excel Discussion (Misc queries) | |||
Excel / VB is driving me nuts!! | Excel Worksheet Functions |