Need help on salary (pieces of money)

[elricsia]

Dear All,

I need some help. My company pay salary by cash and we have total 70 person.

I want to create a automatic calculation on pieces of money needed but i don't know how to do that.

Ex:

RM1,532.85 for this month salary and i need an automatic calculation as below:

RM100.00 = 15
RM50.00 = 0
RM20.00 = 1
RM10.00 = 1
RM5.00 = 0
RM1.00 = 2
RM0.50 = 1
RM0.20 = 1
RM0.10 = 1
RM0.05 = 1


Thank you!

[daddylonglegs]

If you list the currency amounts in B1:K1 then with your salary in A3 use this formula in B3

=INT(A3/B$1)

and this formula in C3 copied across

=INT(ROUND(($A3-SUMPRODUCT($B$1:B$1,$B3:B3)),5)/C$1)

See attached - I formatted so that zeroes don't appear and added a "check" column to check that the amounts shown will add to the correct salray

[elricsia]

If you list the currency amounts in B1:K1 then with your salary in A3 use this formula in B3

=INT(A3/B$1)

and this formula in C3 copied across

=INT(ROUND(($A3-SUMPRODUCT($B$1:B$1,$B3:B3)),5)/C$1)

See attached - I formatted so that zeroes don't appear and added a "check" column to check that the amounts shown will add to the correct salray

Thank you for your help.