Denomination

[Dollar 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

 

[T. Valko]

Assuming those are your only denominations...

A1 = 1555

D14 = 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$11,E$1:E1))/D2)

 

[Sheeloo]

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...