Skip to content

Excel Functions

Excel f(x)s = Excel Functions

6174 Kaprekar’s constant Basic Math
DayName Date and Time
Filter. Google Sheets function Google Sheets
LastSunday, LastSaturday Date and Time
Limited Ceiling Basic Math
CamelCase to Camel Case CHAR
Show developer tab Excel User tips
Excel Functions = XL f(x)s XLfxs

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 keeps converting all cells to “Date” (or Time) Excel User tips
Sheet() and Sheets() Lookup and References
Scorring, saving multiple outputs in 1 number Basic Math
Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
Excel sessions – 2013 VS 2010 Excel User tips
CTRL+Y a mini macro Excel User tips

Search for:

Recent Posts

Stale values (Scratched functions)
Middle name + 1st name
LastSunday, LastSaturday
Paste Special Percentage
Jan8 date format

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 (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

Count cells with condition – multiple conditions COUNTIFS
Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
LastSunday, LastSaturday Date and Time
CHOOSE – tree of decisions CHOOSE
Expenses calendar, FaCal Basic Math
Excel Limits Excel User tips
0% interest promotion Basic Math
Week number to Sunday date – Weeknum reverse DATE

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme