Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Middle name + 1st name Basic Math
  • Extract Address into table Formulas - combined functions
  • CTRL+Y a mini macro Excel User tips
  • Min Max vehicle Formulas - combined functions
  • Multiple Dual-Validations COUNTA
  • MID + SEARCH to convert cell to rows MID
  • Count how many times letter found Formulas - combined functions
  • Return 12 values in one number AND

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 early college days, and love just kept going on and on.

Now, after I start working with websites and managed few, it is the best time to start one for my love.

 

XL f(x)s

XLfxs

Post navigation

Next Post: Hyperlink usage and HyperlinkOf UDF

Related Posts

  • When Excel functions are not enough Excel User tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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
  • SimpleANBox Basic Math
  • Limited Ceiling Basic Math
  • Extract current (Active) workbook name CELL
  • Sort list dynamically (functions) COLUMN
  • Worksheet name, dynamically using formula CELL
  • Fx to cut long column into two columns Formulas - combined functions
  • Highlight dates dynamically AND
  • Convert 2-column into wide (column-row) table Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme