Thread: best breakdown
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ekkeindoha ekkeindoha is offline
external usenet poster
 
Posts: 46
Default 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