Microsoft Excel — Function Directory
Browse 116 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by Microsoft Excel.
116 functions
Browse by category
A
- ABSLearn the ABS formula in Microsoft Excel: get a nonnegative magnitude without changing absolute size, with reproducible …
- AGGREGATELearn how to calculate an aggregate while explicitly controlling which errors or hidden rows are ignored in Microsoft Excel. …
- ANDLearn the AND formula in Microsoft Excel: require several conditions to be true, with reproducible examples, expected answers …
- AVERAGELearn the AVERAGE formula in Microsoft Excel: calculate the arithmetic mean of numeric cells, with reproducible examples, …
- AVERAGEIFLearn the AVERAGEIF formula in Microsoft Excel: average numbers matching a single condition, with reproducible examples, …
- AVERAGEIFSLearn the AVERAGEIFS formula in Microsoft Excel: average numeric values that meet multiple conditions, with reproducible …
C
- CHARCHAR in Microsoft Excel: construct a character from a numeric code, with a critical distinction between Excel code pages and …
- CHOOSELearn how to select one of several values by its 1-based index in Microsoft Excel. Includes syntax, two verified-by-reasoning …
- CHOOSECOLSLearn how to return selected columns from a wider table in the order you specify in Microsoft Excel. Includes syntax, two …
- CHOOSEROWSLearn how to return rows from a source table in an arbitrary order in Microsoft Excel. Includes syntax, two …
- CLEANCLEAN in Microsoft Excel: remove ASCII control characters from imported text without pretending to remove every invisible …
- CODECODE in Microsoft Excel: inspect the numeric code of the first character in a text value. Includes worked examples and …
- CONCATENATELearn the CONCATENATE formula in Microsoft Excel: join text fragments into one text string, with reproducible examples, …
- COUNTLearn the COUNT formula in Microsoft Excel: count numeric cells without counting text, with reproducible examples, expected …
- COUNTALearn the COUNTA formula in Microsoft Excel: count cells containing values including text, with reproducible examples, …
- COUNTBLANKLearn the COUNTBLANK formula in Microsoft Excel: count physically blank cells in a range, with reproducible examples, …
- COUNTIFLearn the COUNTIF formula in Microsoft Excel: count records matching one criterion, with reproducible examples, expected …
- COUNTIFSLearn the COUNTIFS formula in Microsoft Excel: count rows meeting multiple aligned conditions, with reproducible examples, …
D
- DATELearn the DATE formula in Microsoft Excel: build a real date from numeric components, with reproducible examples, expected …
- DATEDIFLearn how to measure completed years or days between two dates without counting partial anniversaries as full years in …
- DAYLearn the DAY formula in Microsoft Excel: extract the day of month from a date, with reproducible examples, expected answers …
- DAYSDAYS in Microsoft Excel: find an elapsed calendar-day difference with the end date supplied first. Includes worked examples …
- DROPLearn how to remove headers or trailing records from an expanding array in Microsoft Excel. Includes syntax, two …
E
- EDATEEDATE in Microsoft Excel: move a date by a specified number of calendar months rather than a fixed number of days. Includes …
- EOMONTHLearn the EOMONTH formula in Microsoft Excel: find the final calendar day of an offset month, with reproducible examples, …
- EXACTEXACT in Microsoft Excel: compare two text values with case and spaces included in the comparison. Includes worked examples …
- EXPEXP in Microsoft Excel: calculate e raised to a power for an explicitly exponential model. Includes worked examples and …
F
H
I
- IFLearn the IF formula in Microsoft Excel: choose between two outcomes using a logical test, with reproducible examples, …
- IFERRORLearn the IFERROR formula in Microsoft Excel: replace a formula error with a chosen fallback, with reproducible examples, …
- IFNALearn the IFNA formula in Microsoft Excel: catch unavailable lookup results without hiding other errors, with reproducible …
- IFSLearn how to return the first matching outcome from several ordered conditions in Microsoft Excel. Includes syntax, two …
- INDEXLearn the INDEX formula in Microsoft Excel: return the value at a position inside a range, with reproducible examples, …
- INDIRECTLearn how to turn a text address into a live cell reference in Microsoft Excel. Includes syntax, two verified-by-reasoning …
- INTINT in Microsoft Excel: round down toward negative infinity rather than merely remove decimal digits. Includes worked …
- ISBLANKLearn the ISBLANK formula in Microsoft Excel: check whether a cell is truly empty, with reproducible examples, expected …
- ISERRISERR in Microsoft Excel: test for an actual error other than #N/A. Includes worked examples and application-specific …
- ISERRORISERROR in Microsoft Excel: test for an actual error value of any type. Includes worked examples and application-specific …
- ISNAISNA in Microsoft Excel: test specifically for the #N/A error value. Includes worked examples and application-specific …
- ISNUMBERLearn the ISNUMBER formula in Microsoft Excel: determine whether a value is numerical, with reproducible examples, expected …
L
- LAMBDALearn how to make an inline reusable calculation without using VBA or Apps Script in Microsoft Excel. Includes syntax, two …
- LARGEUse LARGE in Microsoft Excel with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- LEFTLearn the LEFT formula in Microsoft Excel: extract a set number of characters from the start of text, with reproducible …
- LENLearn the LEN formula in Microsoft Excel: measure the number of characters in a text string, with reproducible examples, …
- LETLearn how to name intermediate formula values to avoid duplicating a calculation in Microsoft Excel. Includes syntax, two …
- LNLN in Microsoft Excel: calculate a natural logarithm for a strictly positive real input. Includes worked examples and …
- LOGLOG in Microsoft Excel: calculate a logarithm in an explicit base, with base 10 used when omitted. Includes worked examples …
- LOG10LOG10 in Microsoft Excel: calculate a base-10 logarithm for positive inputs without an optional-base argument. Includes …
- LOOKUPLearn how to find an approximate match in a sorted key column and return a corresponding category in Microsoft Excel. …
- LOWERLearn the LOWER formula in Microsoft Excel: convert uppercase letters to lowercase, with reproducible examples, expected …
M
- MATCHLearn the MATCH formula in Microsoft Excel: find the relative position of a matching key, with reproducible examples, …
- MAXLearn the MAX formula in Microsoft Excel: find the largest numeric value, with reproducible examples, expected answers and …
- MEDIANUse MEDIAN in Microsoft Excel with three worked numeric examples, CSV practice data, interpretation checks, and …
- MIDLearn the MID formula in Microsoft Excel: extract a fixed-length substring from a position, with reproducible examples, …
- MINLearn the MIN formula in Microsoft Excel: find the smallest numeric value, with reproducible examples, expected answers and …
- MODLearn the MOD formula in Microsoft Excel: return the remainder with the divisor sign convention, with reproducible examples, …
- MONTHLearn the MONTH formula in Microsoft Excel: extract the month number from a date, with reproducible examples, expected …
N
- NETWORKDAYSLearn how to count workdays in a date interval without manually excluding weekends in Microsoft Excel. Includes syntax, two …
- NOTLearn the NOT formula in Microsoft Excel: reverse a TRUE or FALSE result, with reproducible examples, expected answers and …
- NOWLearn how to return a live date-and-time value, useful for elapsed-time monitoring in Microsoft Excel. Includes syntax, two …
O
P
- PIPI in Microsoft Excel: use the mathematical constant pi in circle and angle calculations without typing a rounded …
- POWERPOWER in Microsoft Excel: raise a number to an exponent, including roots and reciprocal powers. Includes worked examples and …
- PRODUCTPRODUCT in Microsoft Excel: multiply numeric factors or ranges together instead of adding them or summing row-wise products. …
- PROPERPROPER in Microsoft Excel: capitalize words for display while recognizing that names and acronyms need review. Includes …
Q
R
- RANK.EQUse RANK.EQ in Microsoft Excel with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- REPLACEREPLACE in Microsoft Excel: replace a known character span by position rather than searching for matching words. Includes …
- REPTREPT in Microsoft Excel: repeat a text unit to build a short display bar, separator or padded label. Includes worked examples …
- RIGHTLearn the RIGHT formula in Microsoft Excel: extract characters from the end of a text value, with reproducible examples, …
- ROUNDLearn the ROUND formula in Microsoft Excel: round to the specified decimal place, with reproducible examples, expected …
- ROUNDDOWNLearn the ROUNDDOWN formula in Microsoft Excel: round toward zero at a specified precision, with reproducible examples, …
- ROUNDUPLearn the ROUNDUP formula in Microsoft Excel: round a number away from zero to a chosen precision, with reproducible …
S
- SEARCHLearn the SEARCH formula in Microsoft Excel: locate a substring without case-sensitive matching, with reproducible examples, …
- SEQUENCELearn how to generate an automatically expanding numbered sequence for rows, dates or IDs in Microsoft Excel. Includes …
- SIGNSIGN in Microsoft Excel: reduce a numeric value to -1, 0 or 1 according to its direction. Includes worked examples and …
- SMALLUse SMALL in Microsoft Excel with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- SORTLearn the SORT formula in Microsoft Excel: reorder a range based on a chosen column, with reproducible examples, expected …
- SORTBYLearn how to sort one data range using a separate numeric or text key in Microsoft Excel. Includes syntax, two …
- SQRTSQRT in Microsoft Excel: calculate the nonnegative real square root and identify inputs outside the real-valued domain. …
- STDEV.PUse STDEV.P in Microsoft Excel with three worked numeric examples, CSV practice data, interpretation checks, and …
- STDEV.SUse STDEV.S in Microsoft Excel with three worked numeric examples, CSV practice data, interpretation checks, and …
- SUBSTITUTELearn the SUBSTITUTE formula in Microsoft Excel: replace occurrences of text with a new string, with reproducible examples, …
- SUBTOTALLearn how to summarize a filtered list while controlling treatment of hidden rows in Microsoft Excel. Includes syntax, two …
- SUMLearn the SUM formula in Microsoft Excel: add a group of numeric values, with reproducible examples, expected answers and …
- SUMIFLearn the SUMIF formula in Microsoft Excel: sum matching values using one condition, with reproducible examples, expected …
- SUMIFSLearn the SUMIFS formula in Microsoft Excel: sum values when multiple conditions all hold, with reproducible examples, …
- SUMPRODUCTLearn the SUMPRODUCT formula in Microsoft Excel: multiply aligned values row by row and sum the results, with reproducible …
- SWITCHLearn how to map a code to a label without a chain of nested IF formulas in Microsoft Excel. Includes syntax, two …
T
- TAKELearn how to return a specified number of rows or columns from either end of an array in Microsoft Excel. Includes syntax, …
- TEXTLearn how to produce a formatted text label from a number without changing the original numeric cell in Microsoft Excel. …
- TEXTAFTERLearn how to extract the portion of a product code that follows a delimiter in Microsoft Excel. Includes syntax, two …
- TEXTBEFORELearn how to extract the portion of a text identifier before a delimiter in Microsoft Excel. Includes syntax, two …
- TEXTJOINLearn the TEXTJOIN formula in Microsoft Excel: join values with a delimiter while optionally ignoring blanks, with …
- TEXTSPLITLearn how to split a delimited text record into separate spill cells in Microsoft Excel. Includes syntax, two …
- TODAYLearn how to insert the current calendar date without typing it again in Microsoft Excel. Includes syntax, two …
- TRANSPOSELearn how to rotate a rectangular dataset so rows become columns and columns become rows in Microsoft Excel. Includes syntax, …
- TRIMLearn the TRIM formula in Microsoft Excel: remove unwanted ordinary spaces from a text string, with reproducible examples, …
- TRUNCTRUNC in Microsoft Excel: discard digits toward zero at a selected decimal position without rounding up. Includes worked …
U
V
- VALUELearn the VALUE formula in Microsoft Excel: convert recognized numeric text to a number, with reproducible examples, expected …
- VAR.PUse VAR.P in Microsoft Excel with three worked numeric examples, CSV practice data, interpretation checks, and …
- VAR.SUse VAR.S in Microsoft Excel with three worked numeric examples, CSV practice data, interpretation checks, and …
- VLOOKUPLearn the VLOOKUP formula in Microsoft Excel: find a value in the first table column and return another column, with …
- VSTACKLearn how to append rows from two tables into one expanding result in Microsoft Excel. Includes syntax, two …
W
- WEEKDAYLearn how to convert a date into a weekday number to drive scheduling rules in Microsoft Excel. Includes syntax, two …
- WEEKNUMLearn how to calculate a calendar week number for reports without confusing it with ISO week numbering in Microsoft Excel. …
- WORKDAYLearn how to find a due date a set number of working days after an initial date in Microsoft Excel. Includes syntax, two …
X
Y
No functions match your filters. Try a different name or category.