Skip to content

XLf(x)s

Excel functions and formulas

Menu

Array formula
Formulas – combined functions
Google Sheets
Non-functions
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

Author: XLFx

Search

Archives

Meta

Register
Log in

© 2024 XLf(x)s | WordPress Theme by Superb WordPress Themes

Back to Top ↑