Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Scorring, saving multiple outputs in 1 number Basic Math
  • Sum of divide – Array formula Array formula
  • Custom fiscal year calendar (CFlex) Basic Math
  • Tally chart in functions Formulas - combined functions
  • Searching table in 2 dimensions. Formulas - combined functions
  • Validation based on another Validation COUNTA
  • OFFSET+MATCH Formulas - combined functions
  • Get 3rd Wednesday of month 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

  • Count Unique COUNTIF
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • SimpleANBox Basic Math
  • The Excel “&” bug Excel User tips
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Sheet() and Sheets() Lookup and References

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
  • Paste Special Percentage Excel User tips
  • Calculate hours between two cells ABS
  • Always get 1st name (or last) Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Text-to-Columns, dynamically using formulas IFERROR
  • Extract current (Active) workbook name CELL
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Tally chart in functions Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme