Skip to content
XLf(x)s
Excel functions and formulas
Menu
Array formula
Formulas – combined functions
Google Sheets
Non-functions
ActiveX controls
Conditional Formatting
Data Validation
Excel User tips
Format Cells
Graphics
Names
Standard functions
Basic Math
Date and Time
DATE
Hour
MONTH
NETWORKDAYS
TODAY
WEEKDAY
WEEKNUM
YEAR
Engineering
CONVERT
Information
CELL
ISERROR
N
Logical
AND
IF
IFERROR
IFNA
IFS
ISERROR
OR
Lookup and References
ADDRESS
CHOOSE
COLUMN
FORMULATEXT
HLOOKUP
HYPERLINK
INDEX
INDIRECT
MATCH
OFFSET
ROW
VLOOKUP
Math and Trig
ABS
CEILING
COUNT
COUNTA
INT
LARGE
MAX
Min
SMALL
SUM
SUMIF
SUMIFS
SUMPRODUCT
Statistical
COUNTIF
COUNTIFS
Texts and Strings
CHAR
CONCATINATE
FIND
LEFT
Len
MID
REPT
RIGHT
SEARCH
STRING
SUBSTITUTE
TEXT
TRIM
VALUE
Uncategorized
User-Defined f(x)s = UDF
HyperlinkOf
Worksheet
XLfxs
Tag:
shade
Shades of gray
January 25, 2019
We need this to be documented s8mewhere So, here it is...