Skip to content

Excel Functions

Excel f(x)s = Excel Functions

Always get 1st name (or last) Formulas - combined functions
Lesson learned: Do not trust Google Sheets function Google Sheets
Unix DateTime Number Basic Math
CTRL+Y a mini macro Excel User tips
Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
Convert cell into textbox Excel User tips
Excel Limits Excel User tips
Searching table in 2 dimensions. Formulas - combined functions

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

Excel @ before function names in formulas Excel User tips
Sheet() and Sheets() Lookup and References
Expenses calendar, FaCal Basic Math
Convert cell into textbox Excel User tips
Pixel Excel Drawing Format Cells
Recover the unrecoverable Excel User tips

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

Limited Ceiling Basic Math
Insert Blank rows into table using functions CHAR
Count cells with condition – multiple conditions COUNTIFS
Edit directly in cell Excel User tips
Lesson learned: Do not trust Google Sheets function Google Sheets
Tally chart in functions Formulas - combined functions
Sort list dynamically (functions) COLUMN
Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme