Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Convert cell into textbox Excel User tips
  • Stale values (Scratched functions) Excel User tips
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Get 3rd Wednesday of month Basic Math
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Excel @ before function names in formulas Excel User tips
  • Excel ad from early 90s Non-functions
  • Why I ran from =INDIRECT() function Formulas - combined functions

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

  • 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
  • Spreadsheet Compare application Excel User tips
  • Zipcode-State search Formulas - combined functions
  • Comments versus Notes Excel User tips
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Limited Ceiling Basic Math
  • 6174 Kaprekar’s constant Basic Math
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Extract current (Active) workbook name CELL

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme