Denomination breakup

  • Thread starter Thread starter Mel
  • Start date Start date
M

Mel

Hi, From row 4, I have in Column A, names, in column B dollar amounts,
nothing in column C; in D2 50, (for 50 dollars, then in F2 20 (for 20
dollars) etc, after G2 which has 5 in it I have column H nothing, then from
column I to N, 2 then 1 then .50, .20, .10 and lastly .05 (for 5 cents). , I
have the amount of $64.90 but for some reason it does not break up with 1 in
..50c, a 2 in the .20c, (for the coin part) but breaks up with a 1 in each of
the 50c, 20c, 10c and 5c, which is then 5c short??? What is going wrong?
=INT(ROUND(($B3-SUMPRODUCT(($C$2:M$2)*($C3:M3))),2)/N$2) This formula
appears in Column N for the .05 cents

Thanks for any help.
 
Mel,

It worked fine for me, but I would try:

=INT(ROUND(ROUND($B3,2)-ROUND(SUMPRODUCT(($C$2:M$2)*($C3:M3)),2),2)/N$2)

HTH,
Bernie
MS Excel MVP
 
Hi Bernie,

Thank you, that worked.

I don't know if I have formatted the cell incorrectly or because it
transfers automatically from another sheet, it did work fine before but then
something I have done made some thing go wrong.

Thanks for your help.

Mel
 
Back
Top