Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Looplist – Repeating months using formulas Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • BMI Calculator Basic Math
  • FORMULATEXT to show formulas FORMULATEXT
  • Progress bar in pure functions CHAR
  • New function IFERROR, finally IFERROR
  • Walking Columns ActiveX controls
  • Dynamic selection list ActiveX controls

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

  • Middle name + 1st name Basic Math
  • Progress bar in pure functions CHAR
  • SimpleANBox Basic Math
  • BMI Calculator Basic Math
  • Search across sheets in function ADDRESS
  • Multiple Dual-Validations COUNTA

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
  • Custom fiscal year calendar (CFlex) Basic Math
  • Expenses calendar, FaCal Basic Math
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Excel Limits Excel User tips
  • Links between two workbooks – dynamically using functions INDIRECT
  • Looplist – Repeating months using formulas Basic Math
  • Repeated Offset Basic Math
  • OFFSET+MATCH Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme