This is an excerpt from Pierre Leclerc (www.excel-vba.com)

Excel functions and formulas

 

The 2 Most Important

Excel Functions AND
Formulas

 

SUMPRODUCT

AND

INDEX/MATCH

 

 

Annex 10: Excel Spreadsheets Text Functions (24)

There are 24 functions in the "Statistical" category.

Functions What it Does
LEFT Returns the leftmost characters from a text value
LEN Returns the number of characters in a text string
MID Returns a specific number of characters from a text string starting at the position you specify
RIGHT Returns the rightmost characters from a text value
TRIM Removes spaces from text
FIND Finds one text value within another (case-sensitive)
REPT Repeats text a given number of times
TEXT Formats a number and converts it to text
VALUE Converts a text argument to a number
CONCATENATE Joins several text items into one text item
BAHTTEXT Converts a number to text, using the (baht) currency format
CHAR Returns the character specified by the code number
CLEAN Removes all nonprintable characters from text
CODE Returns a numeric code for the first character in a text string
DOLLAR Converts a number to text, using the $ (dollar) currency format
EXACT Checks to see if two text values are identical
FIXED Formats a number as text with a fixed number of decimals
LOWER Converts text to lowercase
PROPER Capitalizes the first letter in each word of a text value
REPLACE Replaces characters within text
SEARCH Finds one text value within another (not case-sensitive)
SUBSTITUTE Substitutes new text for old text in a text string
T Converts its arguments to text
UPPER  Converts text to uppercase

 

 

SUMPRODUCT    INDEX/MATCH    SUBTOTAL    ISERROR    HLOOKUP    LOOKUP    VLOOKUP
AVERAGEIF    AVERAGEIFS   COUNTIF    COUNTIFS    SUMIF    SUMIFS    IFERROR

 

 

 

 

left arrow Back home