Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Shades of gray Graphics
  • Validation based on another Validation COUNTA
  • Schedule column Basic Math
  • Unix DateTime Number Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • 6174 Kaprekar’s constant Basic Math
  • Limited Ceiling Basic Math
  • Insert Blank rows into table using functions CHAR

Category: XLfxs

General XL f(x)s site posts

When Excel functions are not enough

Posted on February 13, 2020 By ANmar
When Excel functions are not enough

BoldCodes

BoldCodes is here to help (BoldCodes.com or Bold.Codes), even though I doubt it, I mean the fact that you cannot do your task in Excel formulas. especially after you understand 25% of these formulas.

But when you do, check out the library of VBA/Excel (aka macros, aka vbscripts) programming codes at BoldCodes.com or Bold.Codes

Excel User tips, Non-functions, XLfxs

Excel Functions = XL f(x)s

Posted on January 21, 2012 By ANmar No Comments on Excel Functions = XL f(x)s

This is the website I have been waiting for a while to create. It should be simple and educational, Excel functions is the love of my life, been always love to work with formulas and solve new issues and problems. That was in early childhood, and then the math came in in high school and…

Read More “Excel Functions = XL f(x)s” »

XLfxs

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
  • Standard math to calculate Aspect Ratio Basic Math
  • Excel @ before function names in formulas Excel User tips
  • Multiple lines in cell using functions CHAR
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • 0% interest promotion Basic Math
  • Paste Special Percentage Excel User tips
  • Count how many times letter found Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme