Skip to content

Excel Functions

Excel f(x)s = Excel Functions

VLookup Lookup and References
CountIf limitation COUNTIF
Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
IFS (and IFNA) to avoid nested IFs Formulas - combined functions
Scorring, saving multiple outputs in 1 number Basic Math
VALUE() of LEFT() Formulas - combined functions
State Abbr with Index+Match+Validation Data Validation
Sheet() and Sheets() Lookup and References

Hello world!

Posted on May 10, 2016 By ANmar No Comments on Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Uncategorized

Post navigation

Previous Post: Workdays – Across months

Next Post: CONVERT function

Related Posts

Count Unique COUNTIF

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

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

GoLast to jump to last cell in a column CELL
BMI Calculator Basic Math
Week number to Month number DATE
Limited Ceiling Basic Math
DayName Date and Time
CHOOSE – tree of decisions CHOOSE
Edit directly in cell Excel User tips
Worksheet name, dynamically using formula CELL

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme