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
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