Microsoft Excel Functions Reference
This PDF contains a large collection of commonly used Microsoft Excel functions grouped by category.
Mathematical Functions
Function Purpose
SUM Adds numbers
AVERAGE Calculates mean
MIN Returns smallest value
MAX Returns largest value
ROUND Rounds numbers
ROUNDUP Rounds upward
ROUNDDOWN Rounds downward
ABS Returns absolute value
MOD Returns remainder
POWER Raises to a power
SQRT Square root
PRODUCT Multiplies numbers
INT Rounds down to integer
CEILING Rounds up to nearest multiple
FLOOR Rounds down to nearest multiple
RAND Random decimal
RANDBETWEEN Random integer
SUMIF Conditional sum
SUMIFS Multiple-condition sum
SUBTOTAL Subtotal calculation
Logical Functions
Function Purpose
IF Returns value based on condition
IFS Multiple conditions
AND Checks if all conditions are true
OR Checks if any condition is true
NOT Reverses logical value
IFERROR Returns alternative if error
IFNA Handles #N/A errors
XOR Exclusive OR logic
SWITCH Matches value to cases
TRUE Returns TRUE
FALSE Returns FALSE
Text Functions
Function Purpose
LEFT Extracts left characters
RIGHT Extracts right characters
MID Extracts middle characters
LEN Counts characters
TRIM Removes extra spaces
UPPER Converts to uppercase
LOWER Converts to lowercase
PROPER Capitalizes words
CONCAT Combines text
TEXTJOIN Joins text with delimiter
FIND Finds text position
SEARCH Searches text position
REPLACE Replaces text
SUBSTITUTE Substitutes text
TEXT Formats numbers as text
VALUE Converts text to number
EXACT Compares text exactly
CLEAN Removes non-printable characters
REPT Repeats text
CHAR Returns character by code
Date and Time Functions
Function Purpose
TODAY Current date
NOW Current date and time
DATE Creates a date
TIME Creates a time
YEAR Extracts year
MONTH Extracts month
DAY Extracts day
HOUR Extracts hour
MINUTE Extracts minute
SECOND Extracts second
DATEDIF Difference between dates
NETWORKDAYS Working days between dates
WORKDAY Future/past working day
EOMONTH End of month
WEEKDAY Day of week
WEEKNUM Week number
Lookup and Reference Functions
Function Purpose
VLOOKUP Vertical lookup
HLOOKUP Horizontal lookup
XLOOKUP Advanced lookup
LOOKUP Searches values
INDEX Returns value by position
MATCH Returns position
XMATCH Advanced MATCH
CHOOSE Selects from list
OFFSET Returns offset range
INDIRECT Creates reference from text
ADDRESS Returns cell address
ROW Returns row number
COLUMN Returns column number
ROWS Counts rows
COLUMNS Counts columns
TRANSPOSE Switches rows and columns
Statistical Functions
Function Purpose
COUNT Counts numbers
COUNTA Counts non-empty cells
COUNTBLANK Counts blank cells
COUNTIF Conditional count
COUNTIFS Multiple-condition count
MEDIAN Middle value
MODE Most frequent value
LARGE Nth largest value
SMALL Nth smallest value
RANK Ranks numbers
PERCENTILE Returns percentile
QUARTILE Returns quartile
STDEV Standard deviation
VAR Variance
CORREL Correlation coefficient
Financial Functions
Function Purpose
PMT Loan payment
PV Present value
FV Future value
NPV Net present value
IRR Internal rate of return
RATE Interest rate
NPER Number of periods
SLN Straight-line depreciation
DB Declining balance depreciation
CUMIPMT Cumulative interest
Dynamic Array Functions
Function Purpose
FILTER Filters data
SORT Sorts data
SORTBY Sorts by another array
UNIQUE Returns unique values
SEQUENCE Creates sequence
RANDARRAY Creates random array
TAKE Takes rows/columns
DROP Drops rows/columns
TOCOL Converts to single column
TOROW Converts to single row
Database Functions
Function Purpose
DSUM Database sum
DCOUNT Database count
DAVERAGE Database average
DMAX Database maximum
DMIN Database minimum
DGET Gets database record
Engineering and Information Functions
Function Purpose
ISNUMBER Checks if number
ISTEXT Checks if text
ISBLANK Checks if blank
ISERROR Checks for error
[Link] Returns error type
TYPE Returns value type
INFO Returns environment info
CELL Returns cell information
NA Returns #N/A
N Converts to number