Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
best breakdown
Can anyone please help wih a formula to show kid's the beakdown of a
currency amount. eg: R35.00 = 1 x R20, 1 x R10 and 1 x R5 R50.00 = 2 x R20 and 1 x R 10 R 9.00 = 1 x R5 and 2 x R2 the currency found are 1,2,5,10,20 and 50 thnks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
best breakdown
Send your email addy to me and I'll send you a file
-- Don Guillett Microsoft MVP Excel SalesAid Software "ekkeindoha" wrote in message ... Can anyone please help wih a formula to show kid's the beakdown of a currency amount. eg: R35.00 = 1 x R20, 1 x R10 and 1 x R5 R50.00 = 2 x R20 and 1 x R 10 R 9.00 = 1 x R5 and 2 x R2 the currency found are 1,2,5,10,20 and 50 thnks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
best breakdown
This is what my worksheet (starting in a1 and going to I2) looks like
x R50 R20 R10 R5 R2 R1 x test 67 1 0 1 1 1 0 x 67 I have used x's to show blank cells top row are currency values Formula in B2 (under the R50): =INT($A$2/B1 Formula in C2 (under the R20): =INT(($A$2-SUMPRODUCT($B$1:B1,$B$2:B2))/C1) Carefully note what is absolute ($ symbols) and what is not The formula is copied across to G2 In I2 - to double check my work: =SUMPRODUCT(B1:G1,B2:G2) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "ekkeindoha" wrote in message ... Can anyone please help wih a formula to show kid's the beakdown of a currency amount. eg: R35.00 = 1 x R20, 1 x R10 and 1 x R5 R50.00 = 2 x R20 and 1 x R 10 R 9.00 = 1 x R5 and 2 x R2 the currency found are 1,2,5,10,20 and 50 thnks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
breakdown months | Excel Discussion (Misc queries) | |||
Monthly Breakdown | Excel Worksheet Functions | |||
Excel nervous breakdown | Excel Discussion (Misc queries) | |||
Breakdown | Excel Worksheet Functions | |||
How 2 breakdown $$$ into $ $ $? | Excel Discussion (Misc queries) |