Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Worksheet name, dynamically using formula CELL
  • The Excel “&” bug Excel User tips
  • Highlight dates dynamically AND
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Formula Beautifier Excel User tips
  • Multiple lines in cell using functions CHAR
  • Text-to-Columns, dynamically using formulas IFERROR
  • When Excel tells you to go get some life Excel User tips

Tag: formula

Stale values (Scratched functions)

Posted on June 30, 2025 By ANmar No Comments on Stale values (Scratched functions)
Stale values (Scratched functions)

Excel recently started to show cells with formulas scratched (see screenshot). Looks like this new feature to tell user that these cells will have new values and they are in the process of getting calculated. If you want to disable that feature, uncheck “Show stale values” in “Calculation Options” in “Formula” bar (Screenshot)

Excel User tips, Format Cells, Non-functions, Worksheet

Excel @ before function names in formulas

Posted on August 9, 2022 By ANmar
Excel @ before function names in formulas

Looks like there is a change coming. Excel started adding the symbol @ to some formulas, not sure why only those, but we are waiting to start using this new feature.

Read More “Excel @ before function names in formulas” »

Excel User tips, Formulas - combined functions

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
  • iframe in Excel (XLiFrame) ADDRESS
  • Unix DateTime Number Basic Math
  • Repeated Offset Basic Math
  • Worksheet name, dynamically using formula CELL
  • LastSunday, LastSaturday Date and Time
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • IF with AND and IF with OR AND
  • Get 3rd Wednesday of month Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme