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])

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

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

IFERROR(value, [value_if_error])

UNIQUE(range)

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

TODAY()

ROW([cell_reference])

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

IMPORTRANGE(spreadsheet_url, range_string)

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

UPPER(text)

LOWER(text)

LEN(text)

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

SPARKLINE(data, [options])

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

CONCAT(value1, value2)

ROUND(value, [places])

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

INDIRECT(cell_reference_as_string, [is_A1_notation])

IFNA(value, value_if_na)

HYPERLINK(url, [link_label])

RAND()

NOW()

PROPER(text_to_capitalize)

COLUMN([cell_reference])

RANDBETWEEN(low, high)

NOT(logical_expression)

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

MID(string, starting_at, extract_length)

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

REPT(text_to_repeat, number_of_repetitions)

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

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

CHAR(table_number)

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

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