An Excel file that will determine what cash to return to the buyer (How much of each cash unit, or how many of Fifty dollars and how many of Twenty dollars and so on) in a very interesting way using as less functions as needed
So, if you need to return 15.45, this file will tell you (1 of 10 + 1 of 5 + 4 dims and 1 nickel)
It is very easy way to show that using functions only
Plus, you can change bills/coins and amounts will be updated instantly, try it
It is widely used by Accountants or cashiers to determine what to return to the buyer once you know the amount of the amount and the payments
Formula in column D is:
=C13-B13
While columns F through O all have the same formula, which is:
=IF(INT(($D13-SUMPRODUCT($E13:E13,$E$12:E$12))/F$12)=0,"-",INT(($D13-SUMPRODUCT($E13:E13,$E$12:E$12))/F$12))
