Cash Denomination Calc returning incorrect values

[rcarmichael]

Hello,
I am creating a calculator to make cashup of our drawer easier at the end of the day; the premise is that when we cash up there should be only $800 left in the drawer, and the largest denominations should be removed first in order to make that happen (JENI).
I am currently using

INT(($D$2-SUMPRODUCT($A$2:$A2,F$2:F2))/$A3

which works 85% of the time, but as you can see from my demo on Google Drive it sometimes returns the incorrect value (that is, the sum of the money to be removed and kept does not match what it should).
Does anyone have any idea why this would be? Any assistance is greatly appreciated.
Ryan

 

[StephenCrump]

F3: =MIN(B3,INT(ROUND($D$2-SUMPRODUCT($A$2:$A2,F$2:F2),2)/$A3))

(to avoid floating point rounding error)

 

[Dave Patton]

Edit the coins I included 0.25

T1104b.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
2	Total	Drawer	Amount	$100	$50	$20	$10	$5	$2	$1	$0.50	$0.25	$0.10	$0.05	$0.01
3	2,073.35	800.00	1,273.35	12	1	1	0	0	1	1	0	1	1	0	0
1bb

Cell Formulas
Range	Formula
C3	C3	=A3-B3
D3	D3	=INT($C3/D$2)
E3:O3	E3	=INT(ROUND($C3-SUMPRODUCT($D3:D3,$D$2:D$2),2)/E$2)

 

[rcarmichael]

F3: =MIN(B3,INT(ROUND($D$2-SUMPRODUCT($A$2:$A2,F$2:F2),2)/$A3))

(to avoid floating point rounding error)

Thank you @StephenCrump !

 

[rcarmichael]

Edit the coins I included 0.25

Where I'm from (Australia) we don't have 25c and 1c coins

 

[Dave Patton]

"Where I'm from (Australia) we don't have 25c and 1c coin"
That is why I said Edit the coins; I noticed that after I posted the suggestion!
A post with XL2BB is much better than an image.
Your profile doesn't show Australia. Your profile could be updated to show Excel version.

Thanks for the feedback.