If, for example, one labourers 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

--
Biff
Microsoft Excel MVP


"Owl" wrote in message
...
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

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" wrote:

This is obviously not based on USD...

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

--
Biff
Microsoft Excel MVP


"Owl" wrote in message
...
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

what is USD (US Dollars perhaps?)?

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

--
Biff
Microsoft Excel MVP


"Owl" wrote in message
...
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" wrote:

This is obviously not based on USD...

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

--
Biff
Microsoft Excel MVP


"Owl" wrote in message
...
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