Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Zipcode-State search Formulas - combined functions
  • Multiple-Validations (connected to each other) Data Validation
  • Excel Functions = XL f(x)s XLfxs
  • Validation based on another Validation COUNTA
  • Edit directly in cell Excel User tips
  • IF with AND and IF with OR AND
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Expenses calendar, FaCal Basic Math

Category: Format Cells

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

Pixel Excel Drawing

Posted on August 22, 2022 By ANmar
Pixel Excel Drawing

This guy has nothing to stop him

Format Cells, Graphics, Non-functions

Comments versus Notes

Posted on August 1, 2022 By ANmar
Comments versus Notes

It is official and looks better now, I know it might be confusing, but I liked it so far

Excel now has “Comments”, the classic Comments are now called “Notes”

I used Notes a lot, mainly to remind me of certain expectations of some cells, or guide the user to some additional info about some cells, so got confused when I tried to insert Comment into cell.

Read More “Comments versus Notes” »

Excel User tips, Format Cells, Non-functions

Blank (isempty) VS “” (null string)

Posted on February 18, 2020 By ANmar
Blank (isempty) VS “” (null string)

If formula results in “”, then that cell will not be empty.When copy and paste as values, it will not be empty either.VersusWhen we use VBA (Macro command) Range.value = Range.value For that “” cell, it will make destination cell as empty. Sorting table will consider cells with “” as 0, while empty cells are…

Read More “Blank (isempty) VS “” (null string)” »

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

Excel keeps converting all cells to “Date” (or Time)

Posted on February 14, 2020 By ANmar
Excel keeps converting all cells to “Date” (or Time)

Issue found several times in xls or xlsx, to get it fix https://www.mrexcel.com/forum/excel-questions/637277-excel-converting-numbers-dates.html

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

Cell formats 0.0\% and 0.0%;(0.0%)

Posted on April 7, 2019 By ANmar
Cell formats 0.0\% and 0.0%;(0.0%)

We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format a cell in Excel, to show %, it automatically divide that number by 100 But we do not want that to happen this time. So here is the trick, in…

Read More “Cell formats 0.0\% and 0.0%;(0.0%)” »

Format Cells, Non-functions, Worksheet

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
  • Calculate hours between two cells ABS
  • Search across sheets in function ADDRESS
  • CountIf limitation COUNTIF
  • VLookup Lookup and References
  • BMI Calculator Basic Math
  • Excel @ before function names in formulas Excel User tips
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Walking Columns ActiveX controls

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme