Money Break Up

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

Mel

I am also wondering if there is a way to take a $ value and get it
broken down to the notes/coin required for cash.

e.g. is I have to pay $285.75 then it might look like this
$285.75 5 under the $50 column, 1 under the $20 column, 1 under the $10
column, 1 under the $5 column, 1 under the 50cent column and 1 under the
..20cent column and 1 under the .5cent column.

Thanks
Mel
 
Hi Mel

In cells C1:M1 enter 50, 20, 10 etc. through to .01 for the denominations
you wish to pay.
In A2 enter the amount to be paid.
Leave column B totally blank
in cell C2 enter
=INT(ROUND(($A2-SUMPRODUCT(($B$1:B$1)*($B2:B2))),2)/C$1)
and copy across through D2:N2

You can copy C2:N2 down for as many rows as you wish
 
Hi Mel

slight error in my posting.
The range to copy to should have been D2:M2, not D2:N2 but I guess you
figured that out.
 
In c3
=C1*C2
in d3:>>>>>>>>
=IF(OR(C3="",C3=$A$2),"",(D1*D2)+C3)
copy across>>>>
 
Back
Top