Skip to content

Excel Functions

Excel f(x)s = Excel Functions

Text-to-Columns, dynamically using formulas IFERROR
Why I ran from =INDIRECT() function Formulas - combined functions
Unix DateTime Number Basic Math
Return 12 values in one number AND
OFFSET+MATCH Formulas - combined functions
Looplist – Repeating months using formulas Basic Math
Standard math to calculate Aspect Ratio Basic Math
CONVERT function CONVERT

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

Highlight dates dynamically AND
CountIf limitation COUNTIF
Why I ran from =INDIRECT() function Formulas - combined functions
UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
Count how many times letter found Formulas - combined functions
Always get 1st name (or last) Formulas - combined functions
Cells with additional spaces AND
Middle name + 1st name Basic Math

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme