Google Sheets — Function Directory
Browse 123 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by Google Sheets.
123 functions
Browse by category
A
- ABSLearn the ABS formula in Google Sheets: get a nonnegative magnitude without changing absolute size, with reproducible …
- ANDLearn the AND formula in Google Sheets: require several conditions to be true, with reproducible examples, expected answers …
- ARRAY_CONSTRAINLearn how to limit an array result to a fixed number of rows and columns in Google Sheets. Includes syntax, two …
- ARRAYFORMULALearn how to apply a calculation to every row of one or more ranges without copying the formula in Google Sheets. Includes …
- AVERAGELearn the AVERAGE formula in Google Sheets: calculate the arithmetic mean of numeric cells, with reproducible examples, …
- AVERAGEIFLearn the AVERAGEIF formula in Google Sheets: average numbers matching a single condition, with reproducible examples, …
- AVERAGEIFSLearn the AVERAGEIFS formula in Google Sheets: average numeric values that meet multiple conditions, with reproducible …
B
C
- CHARCHAR in Google Sheets: 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 Google Sheets. Includes syntax, two verified-by-reasoning …
- CHOOSECOLSLearn how to return selected columns from a wider table in the order you specify in Google Sheets. Includes syntax, two …
- CHOOSEROWSLearn how to return rows from a source table in an arbitrary order in Google Sheets. Includes syntax, two …
- CLEANCLEAN in Google Sheets: remove ASCII control characters from imported text without pretending to remove every invisible …
- CODECODE in Google Sheets: inspect the numeric code of the first character in a text value. Includes worked examples and …
- CONCATENATELearn the CONCATENATE formula in Google Sheets: join text fragments into one text string, with reproducible examples, …
- COUNTLearn the COUNT formula in Google Sheets: count numeric cells without counting text, with reproducible examples, expected …
- COUNTALearn the COUNTA formula in Google Sheets: count cells containing values including text, with reproducible examples, expected …
- COUNTBLANKLearn the COUNTBLANK formula in Google Sheets: count physically blank cells in a range, with reproducible examples, expected …
- COUNTIFLearn the COUNTIF formula in Google Sheets: count records matching one criterion, with reproducible examples, expected …
- COUNTIFSLearn the COUNTIFS formula in Google Sheets: count rows meeting multiple aligned conditions, with reproducible examples, …
- COUNTUNIQUELearn how to count the distinct values in a set of text labels in Google Sheets. Includes syntax, two verified-by-reasoning …
D
- DATELearn the DATE formula in Google Sheets: 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 Google …
- DAYLearn the DAY formula in Google Sheets: extract the day of month from a date, with reproducible examples, expected answers …
- DAYSDAYS in Google Sheets: find an elapsed calendar-day difference with the end date supplied first. Includes worked examples and …
E
- EDATEEDATE in Google Sheets: move a date by a specified number of calendar months rather than a fixed number of days. Includes …
- EOMONTHLearn the EOMONTH formula in Google Sheets: find the final calendar day of an offset month, with reproducible examples, …
- EXACTEXACT in Google Sheets: compare two text values with case and spaces included in the comparison. Includes worked examples and …
- EXPEXP in Google Sheets: calculate e raised to a power for an explicitly exponential model. Includes worked examples and …
F
- FILTERLearn the FILTER formula in Google Sheets: return only rows meeting a Boolean condition, with reproducible examples, expected …
- FINDLearn the FIND formula in Google Sheets: locate a case-sensitive substring position, with reproducible examples, expected …
- FLATTENLearn how to turn a two-dimensional range into one continuous column of values in Google Sheets. Includes syntax, two …
H
I
- IFLearn the IF formula in Google Sheets: choose between two outcomes using a logical test, with reproducible examples, expected …
- IFERRORLearn the IFERROR formula in Google Sheets: replace a formula error with a chosen fallback, with reproducible examples, …
- IFNALearn the IFNA formula in Google Sheets: catch unavailable lookup results without hiding other errors, with reproducible …
- IFSLearn how to return the first matching outcome from several ordered conditions in Google Sheets. Includes syntax, two …
- INDEXLearn the INDEX formula in Google Sheets: return the value at a position inside a range, with reproducible examples, expected …
- INDIRECTLearn how to turn a text address into a live cell reference in Google Sheets. Includes syntax, two verified-by-reasoning …
- INTINT in Google Sheets: round down toward negative infinity rather than merely remove decimal digits. Includes worked examples …
- ISBLANKLearn the ISBLANK formula in Google Sheets: check whether a cell is truly empty, with reproducible examples, expected answers …
- ISERRISERR in Google Sheets: test for an actual error other than #N/A. Includes worked examples and application-specific cautions.
- ISERRORISERROR in Google Sheets: test for an actual error value of any type. Includes worked examples and application-specific …
- ISNAISNA in Google Sheets: test specifically for the #N/A error value. Includes worked examples and application-specific …
- ISNUMBERLearn the ISNUMBER formula in Google Sheets: 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 Google Sheets. Includes syntax, two …
- LARGEUse LARGE in Google Sheets with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- LEFTLearn the LEFT formula in Google Sheets: extract a set number of characters from the start of text, with reproducible …
- LENLearn the LEN formula in Google Sheets: 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 Google Sheets. Includes syntax, two …
- LNLN in Google Sheets: calculate a natural logarithm for a strictly positive real input. Includes worked examples and …
- LOGLOG in Google Sheets: calculate a logarithm in an explicit base, with base 10 used when omitted. Includes worked examples and …
- LOG10LOG10 in Google Sheets: calculate a base-10 logarithm for positive inputs without an optional-base argument. Includes worked …
- LOOKUPLearn how to find an approximate match in a sorted key column and return a corresponding category in Google Sheets. Includes …
- LOWERLearn the LOWER formula in Google Sheets: convert uppercase letters to lowercase, with reproducible examples, expected …
M
- MAPLearn how to transform each element of an array using a small named LAMBDA rule in Google Sheets. Includes syntax, two …
- MATCHLearn the MATCH formula in Google Sheets: find the relative position of a matching key, with reproducible examples, expected …
- MAXLearn the MAX formula in Google Sheets: find the largest numeric value, with reproducible examples, expected answers and …
- MEDIANUse MEDIAN in Google Sheets with three worked numeric examples, CSV practice data, interpretation checks, and …
- MIDLearn the MID formula in Google Sheets: extract a fixed-length substring from a position, with reproducible examples, …
- MINLearn the MIN formula in Google Sheets: find the smallest numeric value, with reproducible examples, expected answers and …
- MODLearn the MOD formula in Google Sheets: return the remainder with the divisor sign convention, with reproducible examples, …
- MONTHLearn the MONTH formula in Google Sheets: extract the month number from a date, with reproducible examples, expected answers …
N
- NETWORKDAYSLearn how to count workdays in a date interval without manually excluding weekends in Google Sheets. Includes syntax, two …
- NOTLearn the NOT formula in Google Sheets: 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 Google Sheets. Includes syntax, two …
O
P
- PIPI in Google Sheets: use the mathematical constant pi in circle and angle calculations without typing a rounded …
- POWERPOWER in Google Sheets: raise a number to an exponent, including roots and reciprocal powers. Includes worked examples and …
- PRODUCTPRODUCT in Google Sheets: multiply numeric factors or ranges together instead of adding them or summing row-wise products. …
- PROPERPROPER in Google Sheets: capitalize words for display while recognizing that names and acronyms need review. Includes worked …
Q
R
- RANK.EQUse RANK.EQ in Google Sheets with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- REDUCELearn how to fold a range of values into one accumulated output using LAMBDA in Google Sheets. Includes syntax, two …
- REGEXEXTRACTLearn how to pull a structured code out of a longer piece of text in Google Sheets. Includes syntax, two …
- REGEXMATCHLearn how to check whether a text value follows a predictable identifier pattern in Google Sheets. Includes syntax, two …
- REGEXREPLACELearn how to standardize inconsistent text by replacing regex-matched fragments in Google Sheets. Includes syntax, two …
- REPLACEREPLACE in Google Sheets: replace a known character span by position rather than searching for matching words. Includes …
- REPTREPT in Google Sheets: repeat a text unit to build a short display bar, separator or padded label. Includes worked examples …
- RIGHTLearn the RIGHT formula in Google Sheets: extract characters from the end of a text value, with reproducible examples, …
- ROUNDLearn the ROUND formula in Google Sheets: round to the specified decimal place, with reproducible examples, expected answers …
- ROUNDDOWNLearn the ROUNDDOWN formula in Google Sheets: round toward zero at a specified precision, with reproducible examples, …
- ROUNDUPLearn the ROUNDUP formula in Google Sheets: round a number away from zero to a chosen precision, with reproducible examples, …
S
- SCANLearn how to return each intermediate accumulated result instead of only the final total in Google Sheets. Includes syntax, …
- SEARCHLearn the SEARCH formula in Google Sheets: 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 Google Sheets. Includes syntax, …
- SIGNSIGN in Google Sheets: reduce a numeric value to -1, 0 or 1 according to its direction. Includes worked examples and …
- SMALLUse SMALL in Google Sheets with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- SORTLearn the SORT formula in Google Sheets: reorder a range based on a chosen column, with reproducible examples, expected …
- SPLITLearn how to split a delimited label into multiple horizontal cells in Google Sheets. Includes syntax, two …
- SQRTSQRT in Google Sheets: calculate the nonnegative real square root and identify inputs outside the real-valued domain. …
- STDEV.PUse STDEV.P in Google Sheets with three worked numeric examples, CSV practice data, interpretation checks, and …
- STDEV.SUse STDEV.S in Google Sheets with three worked numeric examples, CSV practice data, interpretation checks, and …
- SUBSTITUTELearn the SUBSTITUTE formula in Google Sheets: 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 Google Sheets. Includes syntax, two …
- SUMLearn the SUM formula in Google Sheets: add a group of numeric values, with reproducible examples, expected answers and …
- SUMIFLearn the SUMIF formula in Google Sheets: sum matching values using one condition, with reproducible examples, expected …
- SUMIFSLearn the SUMIFS formula in Google Sheets: sum values when multiple conditions all hold, with reproducible examples, expected …
- SUMPRODUCTLearn the SUMPRODUCT formula in Google Sheets: 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 Google Sheets. Includes syntax, two …
T
- TEXTLearn how to produce a formatted text label from a number without changing the original numeric cell in Google Sheets. …
- TEXTJOINLearn the TEXTJOIN formula in Google Sheets: join values with a delimiter while optionally ignoring blanks, with reproducible …
- TOCOLLearn how to convert any rectangular table into a single column with optional blank handling in Google Sheets. Includes …
- TODAYLearn how to insert the current calendar date without typing it again in Google Sheets. Includes syntax, two …
- TOROWLearn how to reshape a rectangular table into one horizontal row in Google Sheets. Includes syntax, two verified-by-reasoning …
- TRANSPOSELearn how to rotate a rectangular dataset so rows become columns and columns become rows in Google Sheets. Includes syntax, …
- TRIMLearn the TRIM formula in Google Sheets: remove unwanted ordinary spaces from a text string, with reproducible examples, …
- TRUNCTRUNC in Google Sheets: discard digits toward zero at a selected decimal position without rounding up. Includes worked …
U
V
- VALUELearn the VALUE formula in Google Sheets: convert recognized numeric text to a number, with reproducible examples, expected …
- VAR.PUse VAR.P in Google Sheets with three worked numeric examples, CSV practice data, interpretation checks, and …
- VAR.SUse VAR.S in Google Sheets with three worked numeric examples, CSV practice data, interpretation checks, and …
- VLOOKUPLearn the VLOOKUP formula in Google Sheets: 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 Google Sheets. Includes syntax, two …
W
- WEEKDAYLearn how to convert a date into a weekday number to drive scheduling rules in Google Sheets. Includes syntax, two …
- WEEKNUMLearn how to calculate a calendar week number for reports without confusing it with ISO week numbering in Google Sheets. …
- WORKDAYLearn how to find a due date a set number of working days after an initial date in Google Sheets. Includes syntax, two …
X
Y
No functions match your filters. Try a different name or category.