Count how many values are in a list of arguments

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

Round a number down to a specified number of digits

=ROUNDDOWN(number, num_digits)

Returns a value from a list based on an index number.

=CHOOSE(index_num, value1, [value2], ...)

Return the serial number of the current date

=TODAY()

Return the logical value TRUE if the cell contains a number.

=ISNUMBER(value)

Replace part of a text string based on its position with new text.

REPLACE(old_text, start_num, num_chars, new_text)

Returns the median or middle number in a data set.

=MEDIAN(number1, [number2], ...)

Return the logical value TRUE for any error type.

=ISERROR(value)

Return the largest value in a range of values

MAX(number1, [number2], ...)

Replace one or many instances of specific text based on its content (not on its position).

SUBSTITUTE(text, old_text, new_text, [instance_num])

Return the logical value TRUE if a cell contains the #N/A error

=ISBLANK(value)

Sum (add) values in a range that meet multiple specific criteria.

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Return a reference that is a specified number of rows and columns from a starting point

=OFFSET(reference, rows, cols, [height], [width])

Format numbers as text by applying format codes.

TEXT(value, format_text)

Return the value or reference of specified cell(s)

Array form: =INDEX(array, row_num, [column_num])

Reference form: =INDEX(reference, row_num, [column_num], [area_num])