Notes and Coinage for Wages

[Owl]

If, for example, one labourer’s wages for the week are R1843, is there a
simpler way to work out the notes and coins to be got from the bank, than the
following:

In A1: 1843
In B2: =ROUNDDOWN(A2/100,0)
In C2: =ROUNDDOWN(ROUNDDOWN(A2-(B2*100),1)/10,0)
In D2: =A2-(B2*100)-C2*10)

Kind regards
Owl

 

[T. Valko]

This is obviously not based on USD...

B2: =INT(A2/100)
C2: =INT((A2-B2*100)/10)
D2: no change

 

[Owl]

Thank you very much. Forgive my ignorance, but what is USD (US Dollars
perhaps?)? If so, you are right, it is South African rands.

 

[T. Valko]

what is USD (US Dollars perhaps?)?

Yes. We have 100, 50, 20, 10, 5, 2 (although rarely seen), 1 denominations.