Salary sheet

Dear Friends,

I need your help.

Every month I make salary sheet for our company. here everybody having variety of salaries (from 100 to 5000 ). And I divide those salary into 10 , 20, 50, 100, 200, 500 & 1000

Example: See the attachment

Employee Name Salary 1000 500 200 100 50 20 10 5 2 1
A 1654 1 1 0 1 1 0 0 0 2 0
B 854 0 1 1 1 1 0 0 0 2 0

Please give me any formula to do this automatically when I enter that amount ...

Hi, try placing these formulas into B3 to J3

=ROUNDDOWN(B3/1000,0)
=ROUNDDOWN((B3-C3*C1)/D1,0)
=ROUNDDOWN((B3-C3*C1-D3*D1)/E1,0)
=ROUNDDOWN((B3-C3*C1-D3*D1-E3*E1)/F1,0)
=ROUNDDOWN((B3-C3*C1-D3*D1-E3*E1-F3*F1)/G1,0)
=ROUNDDOWN((B3-C3*C1-D3*D1-E3*E1-F3*F1-G3*G1)/H1,0)
=ROUNDDOWN((B3-C3*C1-D3*D1-E3*E1-F3*F1-G3*G1-H3*H1)/I1,0)
=ROUNDDOWN((B3-C3*C1-D3*D1-E3*E1-F3*F1-G3*G1-H3*H1-I3*I1)/J1,0)