Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel ad from early 90s Non-functions
  • Stale values (Scratched functions) Excel User tips
  • Progress bar in pure functions CHAR
  • Week number to Sunday date – Weeknum reverse DATE
  • Calculate hours between two cells ABS
  • CONVERT function CONVERT
  • Excel @ before function names in formulas Excel User tips
  • When Excel functions are not enough Excel User tips

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

  • 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
  • Sheet() and Sheets() Lookup and References
  • Always get 1st name (or last) Formulas - combined functions
  • MID + SEARCH to convert cell to rows MID
  • Excel Limits Excel User tips
  • Links between two workbooks – dynamically using functions INDIRECT
  • 0% interest promotion Basic Math
  • CamelCase to Camel Case CHAR
  • Stale values (Scratched functions) Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme