Notes and Coinage for Wages

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
 
T

T. Valko

This is obviously not based on USD...

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

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

T. Valko

what is USD (US Dollars perhaps?)?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top