Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm looking for a way to have Excel take a given amount of money (say $365)
and break it down into individual bills, largest denomination to smallest (3 hundred-dollar bills, 1 fifty-dollar bill, 1 ten-dollar bill, 1 five-dollar bill.) The initial dollar amount is the result of a formula in a spreadsheet I currently use. I tried rounding using the following formula: =ROUND(D2,-2), where D2 is the cell containing the initial dollar amount. But this has 2 problems: 1) It only works for hundreds, and 2) It rounds up for anything over $49 (so $365 results in 4 hundred dollar bills.) Some additional info... - I'm only working with whole numbers in multiples of 5. In other words, I'll never need to break down $361.77, it would be $360. - The results can either be in "number of bills" or "total dollar amount." For example, either "3" or "$300" for hundreds is fine. Hope I made myself clear. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Breakdown of data in a bar chart | Charts and Charting in Excel | |||
breakdown of buying land and building a home costs | Excel Discussion (Misc queries) | |||
breakdown purchases,sales combined? | New Users to Excel | |||
breakdown a DB4 export into an excel worksheet | Excel Worksheet Functions | |||
Commercial Construction Cost Breakdown Estimate Sheet | Excel Discussion (Misc queries) |