Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Pixel Excel Drawing Format Cells
  • Highlight dates dynamically AND
  • Extract current (Active) workbook name CELL
  • Worksheet name, dynamically using formula CELL
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Looplist – Repeating months using formulas Basic Math
  • Multiple lines in cell using functions CHAR
  • Links between two workbooks – dynamically using functions INDIRECT

6174 Kaprekar’s constant

Posted on September 2, 2022 By ANmar

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar

Just enter any 4 digits number in D3 and watch roads walk you 6174

https://plus.maths.org/content/mysterious-number-6174

Download
Excel Online
Basic Math, Formulas - combined functions, Standard functions, TEXT, Texts and Strings, VALUE Tags:6174, TEXT, VALUE

Post navigation

Previous Post: Pixel Excel Drawing
Next Post: Sorting with functions only

Related Posts

  • Middle name + 1st name Basic Math
  • Cuts string of list of items Formulas - combined functions
  • Dynamic selection list ActiveX controls
  • Links between two workbooks – dynamically using functions INDIRECT
  • Searching table in 2 dimensions. Formulas - combined functions
  • MID + SEARCH to convert cell to rows MID

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
  • IF with AND and IF with OR AND
  • Text-to-Columns, dynamically using formulas IFERROR
  • MID + SEARCH to convert cell to rows MID
  • Workdays – Across months DATE
  • Recover the unrecoverable Excel User tips
  • Edit directly in cell Excel User tips
  • Extract current (Active) workbook name CELL

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme