Currency Denomination Count. [SOLVED]

[James Perry]

Greeting$ friends.


I go the bank to withdraw 200,000 to pay salaries every week to 200 temp employees.

Each emp receives a pay-packet that contains: 2000, 1595, 2675, 1055, 965, and so on.

Denominations of the currency are:

1000, 500, 100, 50, 10, & 5.

What i need:

An Excel formula to withdraw the exact number of notes for each denomination, ( instead of doing the count manually ).

Thank u in advance, friends.


James

 

[NARAYANK991]

Hi James ,


See this file here :


https://www.dropbox.com/s/ge7bmoye8oo3z0r/Perry_Book2.xlsx


Narayan

 

[James Perry]

Thank$. That was quick! Interesting. I am studying it now.

Stay blessed.

James

 

[SirJB7]

Hi, James Perry!


Give a look at this file:

https://dl.dropboxusercontent.com/u/60558749/Currency%20Denomination%20Count.%20%28for%20James%20Perry%20at%20chandoo.org%29.xlsx


It works almost like NARAYANK991, I built this worksheet years ago when had an analogue issue, but as there were little amounts and I withdrew notes from ATM machines sometimes not all notes denominations were available (and sometimes that happened at the cashier posts too), so I needed so specify which denominations were available. I also handles cents.


Regards!


PS: Column B is hidden since it's a dummy column for using a unique SUMPRODUCT formula.

 

[James Perry]

Thank u JB, Sir. I am trying it out.

Regards,

James.

 

[James Perry]

Hello friends, this is what i finally got.


If your denominations are in row 1 from cell B1 and salary in column A from cell A2, then you need 2 formulas only

B2=INT($A2/B$1) and copy down

C2=INT(($A2-SUMPRODUCT($B$1:B$1*$B2:B2))/C$1) and copy right and down.


Best wishes,

James