View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Owl Owl is offline
external usenet poster
 
Posts: 14
Default Notes and Coinage for Wages

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