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.
 

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

Similar Threads

More Planned and Actual Cycle Times 5
Rows to Columns 3
I have a column of numbers, some negative, some positive 3
trying to set conditions for a range of cells 8
Excluding Repeating Numbers Help!1 5
Copy Data from One Spreadsheet to Another ?????? 5
How do I calculate a weighted average and exclude the empthy cells 2
Looking for entries and copying to a cell 1

Back
Top