|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 1st, 2008, 11:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Notes and Coinage for Wages
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 
|
|
#2
August 2nd, 2008, 12:28 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Notes and Coinage for Wages
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
|
|
#3
August 2nd, 2008, 12:44 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Notes and Coinage for Wages
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
|
|
#4
August 2nd, 2008, 12:53 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Notes and Coinage for Wages
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
