Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Searching table in 2 dimensions. Formulas - combined functions
  • Fixed length ID Formulas - combined functions
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Tally chart in functions Formulas - combined functions
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Search across sheets in function ADDRESS
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Highlight dates dynamically 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
  • Sheet() and Sheets() Lookup and References
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Extract current (Active) workbook name CELL
  • Excel Limits Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • Spreadsheet Compare application Excel User tips
  • IF with AND and IF with OR AND
  • Recover the unrecoverable Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme