Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Links between two workbooks – dynamically using functions INDIRECT
  • Hello world! Uncategorized
  • New function IFERROR, finally IFERROR
  • Dynamic selection list ActiveX controls
  • Spreadsheet Compare application Excel User tips
  • Repeated Offset Basic Math
  • Min Max vehicle Formulas - combined functions
  • Calculate hours between two cells ABS

Change Calculator – calculate change in multiple bills/coins

Posted on February 1, 2012 By ANmar No Comments on Change Calculator – calculate change in multiple bills/coins

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))

Formulas - combined functions, IF, INT, Logical, Math and Trig, Standard functions, SUMPRODUCT

Post navigation

Previous Post: UDF – Convert Number into text (English and Arabic)
Next Post: Insert Blank rows into table using functions

Related Posts

  • Scorring, saving multiple outputs in 1 number Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • Count how many times letter found Formulas - combined functions
  • BMI Calculator Basic Math
  • Links between two workbooks – dynamically using functions INDIRECT
  • Search across sheets in function ADDRESS

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • When Excel tells you to go get some life Excel User tips
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Pixel Excel Drawing Format Cells
  • Limited Ceiling Basic Math
  • Sum of divide – Array formula Array formula
  • CHOOSE – tree of decisions CHOOSE
  • OFFSET+MATCH Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme