IF(logical_expression, value_if_true, value_if_false)

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

FILTER(range, condition1, [condition2])

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

ARRAYFORMULA(array_formula)

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

ISBLANK(value)

COUNTIF(range, criterion)

MATCH(search_key, range, [search_type])

TRANSPOSE(array_or_range)

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

IFERROR(value, [value_if_error])

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

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

UNIQUE(range)

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

ROW([cell_reference])

TODAY()

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

CONCAT(value1, value2)

IMPORTRANGE(spreadsheet_url, range_string)

LOWER(text)

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

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

LEN(text)

SPARKLINE(data, [options])

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

UPPER(text)

INDIRECT(cell_reference_as_string, [is_A1_notation])

ROUND(value, [places])

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

COLUMN([cell_reference])

IFNA(value, value_if_na)

HYPERLINK(url, [link_label])

RAND()

NOW()

PROPER(text_to_capitalize)

NOT(logical_expression)

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

RANDBETWEEN(low, high)

MID(string, starting_at, extract_length)

FLATTEN(range1,[range2,...])

REPT(text_to_repeat, number_of_repetitions)

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

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

TEXT(number, format)

CHAR(table_number)

FIND(search_for, text_to_search, [starting_at])