Formula for calculating divisibles

Hi All,

have a problem i need to work out, and not sure where to start with this, so hoping you guys can help me out.

say i have 3 columns (singles, tens, and twentys).

i then have a fourth column where a number is typed.

in this scenario, if a user types in 30 into the 4th column, then i need the sheet to enter a 1 in the twenty's column and a 1 in the tens column.
if a user types 56 in the 4th column, then the sheet would enter 2 in the twentys column, 1 in the tens column and 6 in the singles column.

hopefully i am explaining myself ok, and any help is greatly appreciated.

Cheers

Jason

Hello
In cell A2:

=QUOTIENT(D2-B2*10-C2*20,1)

In cell B2:

=QUOTIENT(D2-C2*20,10)

and in cell C2:

=QUOTIENT(D2,20)

Then enter your value in D2 and you can copy down the formulas.

It's possible there's an easier way but it seems to work. Hope this helps.