Notes and Coinage for Wages

  • Thread starter Thread starter Owl
  • Start date Start date
O

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
 
This is obviously not based on USD...

B2: =INT(A2/100)
C2: =INT((A2-B2*100)/10)
D2: no change
 
Thank you very much. Forgive my ignorance, but what is USD (US Dollars
perhaps?)? If so, you are right, it is South African rands.
 
what is USD (US Dollars perhaps?)?

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