Denomination of currency needed to be withdrawn for list of employees

[Juby Koshy via OfficeKB.com]

Problem:
Salary Denomination
1000 500 200 100 50 10 5 1 .50
2650.50 (2) (1) (1) (1) (1)
3493.00 (3) (0) (2) (0) (1) (4) (3)
1675.00 (1) (1) (0) (1) (1) (2) (1)

Etc.Etc.the list would go on.....
What should the formula be for the result (example result in brackets)?

[Juby Koshy via OfficeKB.com]

Hope u got the Idea

the coloumn spacing didn't turn out rite
plz adjust

2750.5 would be 2 thousands note, 1 Five hundreds Note, 2 Hundreds Note, 1
Fiftys Note and 1 Fifty Cents

[Ed Ferrero]

Hi Juby,

Enter the two formulas as shown, copy cell cC3 across, then copy down...


| A | B | C
--------------------------------------------------------------------------------
1 | Salary | Denomination |
2 | | 1000 | 500
3 |2650.5 | =INT($A3/B$2) |
=INT(($A3-(SUMPRODUCT($B3:B3,$B$2:B$2)))/C$2

Ed Ferrero
http://edferrero.m6.net

"Juby Koshy via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> Problem:
> Salary Denomination
> 1000 500 200 100 50 10 5 1 .50
> 2650.50 (2) (1) (1) (1) (1)
> 3493.00 (3) (0) (2) (0) (1) (4) (3)
> 1675.00 (1) (1) (0) (1) (1) (2) (1)
>
> Etc.Etc.the list would go on.....
> What should the formula be for the result (example result in brackets)?

[Juby Koshy via OfficeKB.com]

Thank you soo much
what about for denomination of 200, 100 , 50 , 10 , 5, 1, .50

--
Message posted via http://www.officekb.com

[Juby Koshy via OfficeKB.com]

wow ok got it thanx!!!! Click n drag

--
Message posted via http://www.officekb.com