| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Denomination
Please let me know how to count how many dollar notes containing in a given
amount Ex : 1555/= 1 x 1000 $ Notes 1 x 500 $ Notes 1 x 50 $ Notes 1 x 5 $ Notes Thanking U Upali |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Denomination
Assuming those are your only denominations...
A1 = 1555 D1:D4 = 1000; 500; 50; 5 Enter this formula in E1: =INT(A1/D1) Enter this formula in E2 and copy down to E4: =INT((A$1-SUMPRODUCT(D$1:D1,E$1:E1))/D2) -- Biff Microsoft Excel MVP "Dollar Denomination" <Dollar wrote in message ... Please let me know how to count how many dollar notes containing in a given amount Ex : 1555/= 1 x 1000 $ Notes 1 x 500 $ Notes 1 x 50 $ Notes 1 x 5 $ Notes Thanking U Upali |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Denomination
Download the Excel file from
http://wikisend.com/download/527586/Denominations.xls Pl. test and let us know... Amount should be entered in Col A... This should be handled by code... See http://www.ozgrid.com/VBA/CurrencyToWords.htm for a solution... You will have to add "x " before the denominations and change words to numbers like " Thousand " to " x 1,000 " and so on... "Dollar Denomination" wrote: Please let me know how to count how many dollar notes containing in a given amount Ex : 1555/= 1 x 1000 $ Notes 1 x 500 $ Notes 1 x 50 $ Notes 1 x 5 $ Notes Thanking U Upali |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get denomination | Setting up and Configuration of Excel | |||
| Denomination of currency needed to be withdrawn for list of employees | Charts and Charting in Excel | |||
Linear Mode
