I am from Bosnia And Herzegovina. Our currency is Convertible Marka (KM), and Banknote are: 200, 100, 50, 20, 10 KM, and the Coins in denomination of 5, 2, 1, 0.50, 0.20, 0.10 and 0.05 KM. I need formula that will amount of, for example, 657.55 automatic divide into Banknotes and Coins, by shortest route.

Download Example.

Sorry for "my" english.

Thanks.

In H4:
=INT($D$4/F4)

In H5:
=INT(ROUND(($D$4-SUMPRODUCT(($F$4:$F4*$H$4:$H4))),2) / F5)
... copy that cell down through H14.

In H15:
=($D$4-ROUND(SUMPRODUCT($F$4:$F14*$H$4:$H14),2)) / F15

Exactly what I need. Great answer. You are the best.

Thanks!