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