best breakdown

  • Thread starter Thread starter ekkeindoha
  • Start date Start date
E

ekkeindoha

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