Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Calculate hours between two cells ABS
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Fixed length ID Formulas - combined functions
  • Return 12 values in one number AND
  • Walking Columns ActiveX controls
  • Convert cell into textbox Excel User tips
  • Spreadsheet Compare application Excel User tips
  • Progress bar in pure functions CHAR

Category: SUMPRODUCT

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

Read More “Change Calculator – calculate change in multiple bills/coins” »

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

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Pixel Excel Drawing Format Cells
  • 0% interest promotion Basic Math
  • Multiple Dual-Validations COUNTA
  • GoLast to jump to last cell in a column CELL
  • Searching table in 2 dimensions. Formulas - combined functions
  • Jan8 date format AND
  • CHOOSE – tree of decisions CHOOSE
  • Week number to Month number DATE

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme