{"id":155,"date":"2012-02-01T08:50:33","date_gmt":"2012-02-01T14:50:33","guid":{"rendered":"http:\/\/xlfxs.com\/?p=155"},"modified":"2012-02-01T08:50:33","modified_gmt":"2012-02-01T14:50:33","slug":"change-calculator-calculate-change-in-multiple-billscoins","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=155","title":{"rendered":"Change Calculator &#8211; calculate change in multiple bills\/coins"},"content":{"rendered":"<p><span style=\"font-size: small;\">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<br \/>\nSo, if you need to return 15.45, this file will tell you (1 of 10 + 1 of 5 + 4 dims and 1 nickel)<\/p>\n<p>It is very easy way to show that using functions only<\/p>\n<p><span style=\"color: #339966;\"><em><strong>Plus, you can change bills\/coins and amounts will be updated instantly, try it<\/strong><\/em><\/span><\/p>\n<p>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<\/span><\/p>\n<p>Formula in column D is:<\/p>\n<pre>=C13-B13<\/pre>\n<p>While columns F through O all have the same formula, which is:<\/p>\n<pre>=IF(INT(($D13-SUMPRODUCT($E13:E13,$E$12:E$12))\/F$12)=0,\"-\",INT(($D13-SUMPRODUCT($E13:E13,$E$12:E$12))\/F$12))<\/pre>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/02\/ChangeCalc.zip\"><img decoding=\"async\" class=\"aligncenter\" src=\"\/wp-content\/uploads\/2014\/12\/Download1.png\" alt=\"\" \/><\/a><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>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&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=155\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Change Calculator &#8211; calculate change in multiple bills\/coins&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":157,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,80,86,35,38,6,59],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas","category-if","category-int","category-logical","category-math-and-trig","category-standard_functions","category-sumproduct"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=155"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/155\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/157"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}