Reference / Browse
All formulas
61 reference entries across 7 categories. Filter, sort, and click any for syntax + a runnable example.
61 results
SUM()Returns the sum of a series of numbers and/or cells.MatheasyIF()Returns one value if a condition is TRUE, another if FALSE.LogiceasyQUERY()Runs a Google Visualization API Query Language query across data.ArrayhardSUMIFS()Returns the sum of a range depending on multiple criteria.MathmediumVLOOKUP()Vertical lookup. Searches the first column of a range and returns a value from a specified column.LookupmediumAVERAGE()Returns the numerical average value in a dataset, ignoring text.MatheasyXLOOKUP()The modern replacement for VLOOKUP. Searches any column, returns from any column.LookupmediumCOUNTIF()Returns a conditional count across a range.MatheasyINDEX()Returns the content of a cell at a given row and column in a range.LookupmediumCOUNTIFS()Returns the count of a range depending on multiple criteria.MathmediumIFERROR()Returns the first argument if it isn't an error; otherwise returns the second.LogiceasyFILTER()Returns a filtered version of the source range, returning only rows or columns which meet the conditions.ArraymediumMATCH()Returns the relative position of a value in a range.LookupmediumAND()Returns TRUE if all of the provided arguments are logically true.LogiceasySORT()Sorts the rows of a range by values in one or more columns.ArraymediumARRAYFORMULA()Enables the display of values returned from an array formula into multiple rows/columns.ArrayhardLEFT()Returns a substring from the beginning of a specified string.TexteasyOR()Returns TRUE if any of the provided arguments are logically true.LogiceasyREGEXMATCH()Returns TRUE if a piece of text matches a regular expression.TextmediumRIGHT()Returns a substring from the end of a specified string.TexteasyMAX()Returns the largest numeric value in a dataset.MatheasyCONCATENATE()Appends strings to one another.TexteasyIMPORTRANGE()Imports a range of cells from a specified spreadsheet.WebhardSUBSTITUTE()Replaces existing text with new text in a string. Match by content.TexteasyDATE()Constructs a date value from year, month, and day numbers.DateeasyREGEXEXTRACT()Returns the first matching substring (or first capture group) of a regular expression.TextmediumIFS()Evaluates multiple conditions and returns a value for the first TRUE.LogiceasyDATEDIF()Calculates the number of days, months, or years between two dates.DatemediumIFNA()Returns the first argument unless it is the #N/A error, in which case returns the second.LogiceasyMIN()Returns the smallest numeric value in a dataset.MatheasyWEEKDAY()Returns the day of the week for a date, as a number (default Sunday=1, Saturday=7).DateeasySPLIT()Divides text around a specified character or string.TexteasyLEN()Returns the number of characters in a string.TexteasySEARCH()Returns the position of a substring within a string. Case-insensitive.TexteasyNETWORKDAYS()Returns the count of working days (Mon-Fri) between two dates, excluding optional holidays.DatemediumTEXTJOIN()Combines text with a delimiter, optionally skipping empty cells.TexteasyFIND()Returns the position of a substring within a string. Case-sensitive.TexteasyEOMONTH()Returns the last day of the month a specified number of months before or after a date.DatemediumREGEXREPLACE()Replaces every match of a regular expression with the replacement text.TextmediumUNIQUE()Returns unique rows in the provided source range, discarding duplicates.ArrayeasyROUND()Rounds a number to a certain number of decimal places.MatheasyMID()Returns a segment of a string starting at a given position, for a given length.TexteasySEQUENCE()Generates a sequence of numbers, returned as an array of the requested shape.ArraymediumGOOGLEFINANCE()Fetches current or historical securities information.WebmediumMEDIAN()Returns the median (middle value) of a dataset. Half the values are below, half above.MatheasyEDATE()Returns the date a specified number of months before or after another date.DatemediumROUNDUP()Rounds a number up to the next integer or decimal place, away from zero.MatheasyISBLANK()Returns TRUE if a cell is empty.LogiceasyREPLACE()Replaces part of a string with another string at a specific character position.TextmediumMOD()Returns the remainder after dividing one number by another. MOD(10, 3) = 1.MatheasySORTN()Returns the first n items of a sorted range, for top-N or bottom-N selection.ArrayhardTODAY()Returns the current date as a date value.DateeasyTRIM()Removes leading, trailing, and repeated spaces in text.TexteasyNOT()Returns the opposite of a logical value: NOT(TRUE) = FALSE.LogiceasyYEAR()Returns the year component of a date as a four-digit number.DateeasyISNUMBER()Returns TRUE if a value is a number; useful for guarding numeric expressions.LogiceasyMONTH()Returns the month component of a date as a number from 1 to 12.DateeasyDAY()Returns the day of the month component of a date as a number from 1 to 31.DateeasyNOW()Returns the current date and time as a date value.DateeasyISTEXT()Returns TRUE if a value is a text string.LogiceasyABS()Returns the absolute value of a number.Matheasy