| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding out denominations.!
hi
i'm having values in multiples of 100 in COL A. i want the quotients in COL B [divisor 500] & COL C [divisor 100] explained as under: COL "A" - COL "B" - COL "C" 100 - 0 1 200 - 0 2 500 - 0 5 600 - 1 1 700 - 1 2 1000 - 1 5 1200 - 2 2 1500 - 2 5 1600 - 3 1 1900 - 3 4 2000 - 3 5 2100 - 4 1 2500 - 4 5 50000 - 99 5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding 1st,2nd,3rd etc | Excel Discussion (Misc queries) | |||
| Finding Max or Min Value | Excel Discussion (Misc queries) | |||
| Finding last used | Excel Worksheet Functions | |||
| cash denominations split up | Excel Discussion (Misc queries) | |||
| finding the "end" | New Users to Excel | |||
Threaded Mode
