Returns the character specified by a number

CHAR(number)

Return the serial number of the current date

=TODAY()

Lookup values in vertical or horizontal ranges

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

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

=ISBLANK(value)

Return TRUE or FALSE statements based on testing multiple logical conditions

=AND(logical1, [logical2], ...)

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

REPLACE(old_text, start_num, num_chars, new_text)

Returns the arithmetic mean or average of a data set.

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

Return the largest value in a range of values

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

Return a random number between 0 and 1

=RAND()

Return a list of unique values in an array or range

=UNIQUE(array,[by_col],[exactly_once])

Round a number to a specified number of digits

=ROUND(number, num_digits)

Return the rank of a number in a data set

=RANK.AVG(number,ref,[order])

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

=ISNUMBER(value)

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

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

Return the logical value TRUE if the cell contains any value that is not text.

=ISNONTEXT(value)

Search one row or one column (or an array) for a value

(Vector form) =LOOKUP (lookup_value, lookup_vector, [result_vector])

(Array form) =LOOKUP(lookup_value, array)