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

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

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