Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Progress bar in pure functions CHAR
  • Extract Address into table Formulas - combined functions
  • Cells with additional spaces AND
  • OFFSET+MATCH Formulas - combined functions
  • When Excel functions are not enough Excel User tips
  • Calculate hours between two cells ABS
  • Paste Special Percentage Excel User tips

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

  • VLookup Lookup and References
  • DayName Date and Time
  • iframe in Excel (XLiFrame) ADDRESS
  • CamelCase to Camel Case CHAR
  • Highlight dates dynamically AND
  • Searching table in 2 dimensions. Formulas - combined functions

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
  • Blank (isempty) VS “” (null string) Excel User tips
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Min Max vehicle Formulas - combined functions
  • Multiple-Validations (connected to each other) Data Validation
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Highlight dates dynamically AND

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme