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