Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • The Excel “&” bug Excel User tips
  • Multiple-Validations (connected to each other) Data Validation
  • Comments versus Notes Excel User tips
  • New function IFERROR, finally IFERROR
  • When Excel functions are not enough Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Repeated Offset Basic Math

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

  • Walking Columns ActiveX controls
  • Progress bar in pure functions CHAR
  • Week number to Sunday date – Weeknum reverse DATE
  • Repeated Offset Basic Math
  • FORMULATEXT to show formulas FORMULATEXT
  • CONVERT function CONVERT

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
  • When Excel functions are not enough Excel User tips
  • Multiple lines in cell using functions CHAR
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Custom fiscal year calendar (CFlex) Basic Math
  • Sort list dynamically (functions) COLUMN
  • Multiple Dual-Validations COUNTA
  • WorksheetName and WorksheetsNo UDFs Lookup and References

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme