How to calculate currency denomination for large set of value in Microsoft Excel?

Question

I'm working in a multinational company in Salary Section so i have to calculate the wages of our lbrs. And put them in a pouch and distribute it. Because of large number of labors, i face difficulty in calculating denomination of the cheque. So please help me to find a solution in Microsoft Excel.

eg:

1500

1750

1600

Total=4850

Here

500*9=4500

100*3=300

50*1=50

Total=4850

Thanks in Advance.

Answer 1

Well shipa! its sadath, the profession is common in us. i have a solution for ur prob. mail me on my id i wil send u the prog. (xls) email id: [e-mail]