Skip to content

Excel Functions

Excel f(x)s = Excel Functions

Sum of divide – Array formula Array formula
Cuts string of list of items Formulas - combined functions
iframe in Excel (XLiFrame) ADDRESS
New function IFERROR, finally IFERROR
State Abbr with Index+Match+Validation Data Validation
Stale values (Scratched functions) Excel User tips
Fx to cut long column into two columns Formulas - combined functions
IF with AND and IF with OR AND

When Excel tells you to go get some life

Posted on January 29, 2019 By ANmar

This is what happens when you spend too much time in Excel

Go have a break and get some life

Excel User tips, Non-functions, Worksheet

Post navigation

Previous Post: DayName

Next Post: Cell formats 0.0\% and 0.0%;(0.0%)

Related Posts

Blank (isempty) VS “” (null string) Excel User tips
Spreadsheet Compare application Excel User tips
The Excel “&” bug Excel User tips
Custom fiscal year calendar (CFlex) Basic Math
Excel keeps converting all cells to “Date” (or Time) Excel User tips
Excel ad from early 90s Non-functions

Search for:

Recent Posts

Calculate above and below me
Stale values (Scratched functions)
Middle name + 1st name
LastSunday, LastSaturday
Paste Special Percentage

Archives

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

Unix DateTime Number Basic Math
Tally chart in functions Formulas - combined functions
Compare2, a tool to compare two sheets using formulas Conditional Formatting
CamelCase to Camel Case CHAR
SimpleANBox Basic Math
0% interest promotion Basic Math
Excel Dynamic Drop-Downs that grow with you COUNTA
Sum of divide – Array formula Array formula

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme