Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • The Excel “&” bug Excel User tips
  • Stale values (Scratched functions) Excel User tips
  • Expenses calendar, FaCal Basic Math
  • Edit directly in cell Excel User tips
  • Progress bar in pure functions CHAR
  • Hello world! Uncategorized
  • Extract Address into table Formulas - combined functions
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS

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

  • 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
  • Progress bar in pure functions CHAR
  • Get monthly total from table with dates DATE
  • Blank (isempty) VS “” (null string) Excel User tips
  • Always get 1st name (or last) Formulas - combined functions
  • Cuts string of list of items Formulas - combined functions
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • State Abbr with Index+Match+Validation Data Validation
  • DayName Date and Time

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme