502 Google Sheets Formulas

Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

IF(logical_expression, value_if_true, value_if_false)

Returns a filtered version of the source range, returning only rows or columns which meet the spe...

FILTER(range, condition1, [condition2])

Checks whether the referenced cell is empty.

ISBLANK(value)

Returns the content of a cell, specified by row and column offset.

INDEX(reference, [row], [column])

Returns a count of the number of values in a dataset.

COUNTA(value1, [value2, ...])

Appends strings to one another.

CONCATENATE(string1, [string2, ...])

Returns a conditional count across a range.

COUNTIF(range, criterion)

Enables the display of values returned from an array formula into multiple rows and/or columns an...

ARRAYFORMULA(array_formula)

Divides text around a specified character or string, and puts each fragment into a separate cell ...

SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.

JOIN(delimiter, value_or_array1, [value_or_array2, ...])

Returns the relative position of an item in a range that matches a specified value.

MATCH(search_key, range, [search_type])

Transposes the rows and columns of an array or range of cells.

TRANSPOSE(array_or_range)

Returns the sum of a series of numbers and/or cells.

SUM(value1, [value2, ...])

Vertical lookup. Searches down the first column of a range for a key and returns the value of a s...

VLOOKUP(search_key, range, index, [is_sorted])

Replaces existing text with new text in a string.

SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the...

UNIQUE(range)

Returns the first argument if it is not an error value, otherwise returns the second argument if ...

IFERROR(value, [value_if_error])

Inserts an image into a cell.

IMAGE(url, [mode], [height], [width])

Rounds a number to a certain number of decimal places according to standard rules.

ROUND(value, [places])

Sorts the rows of a given array or range by the values in one or more columns.

SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])

Returns the current date as a date value.

TODAY()

Returns the length of a string.

LEN(text)

Evaluates a value. If the value is an #N/A error, returns the specified value..

IFNA(value, value_if_na)

Imports a range of cells from a specified spreadsheet.

IMPORTRANGE(spreadsheet_url, range_string)

Returns the concatenation of two values. Equivalent to the `&` operator.

CONCAT(value1, value2)

Creates a hyperlink inside a cell.

HYPERLINK(url, [link_label])

Returns the row number of a specified cell.

ROW([cell_reference])

Converts a specified string to lowercase.

LOWER(text)

Tests an expression against a list of cases and returns the corresponding value of the first matc...

SWITCH(expression, case1, value1, [default or case2, value2], …)

Creates a miniature chart contained within a single cell.

SPARKLINE(data, [options])

Returns a cell reference specified by a string.

INDIRECT(cell_reference_as_string, [is_A1_notation])

Returns a uniformly random integer between two values, inclusive.

RANDBETWEEN(low, high)

Returns true if all of the provided arguments are logically true, and false if any of the provide...

AND(logical_expression1, [logical_expression2, ...])

Converts a specified string to uppercase.

UPPER(text)

Returns a random number between 0 inclusive and 1 exclusive.

RAND()

Returns the maximum value in a numeric dataset.

MAX(value1, [value2, ...])

Returns the numerical average value in a dataset, ignoring text.

AVERAGE(value1, [value2, ...])

Returns the current date and time as a date value.

NOW()

Capitalizes each word in a specified string.

PROPER(text_to_capitalize)

Returns specified text repeated a number of times.

REPT(text_to_repeat, number_of_repetitions)

Converts a number into text according to a specified format.

TEXT(number, format)

Returns the column number of a specified cell, with `A=1`.

COLUMN([cell_reference])

Returns the position at which a string is first found within text.

SEARCH(search_for, text_to_search, [starting_at])

Returns a conditional sum across a range.

SUMIF(range, criterion, [sum_range])

Returns the position at which a string is first found within text.

FIND(search_for, text_to_search, [starting_at])

Whether a piece of text matches a regular expression.

REGEXMATCH(text, regular_expression)

Returns the month of the year a specific date falls in, in numeric format.

MONTH(date)

Fetches current or historical securities information from Google Finance.

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])