Calculate all possibilities for receiving change

[homesickhurdle31]

Hi guys, I have a question. Is there a way that Excel can calculate all the possibilities for receiving $2.30 change (in $2 notes, $1 notes, 50 cents, 20 cents, and 10 cents)?


For example,


I can receive $2.30 in 23 ten cents coins, or 21 ten cents coins and 1 twenty cent coin.


Any help would be appreciated. Thanks!

 

[homesickhurdle31]

Hi guys, any help?


I have attached a sample workbook that I have done. But all the values here are done by brute force method.


https://www.dropbox.com/s/kgjika5xs4ylb12/Workbook1.xlsx


Thanks!