Return an array of random decimal or integer numbers between specified values

=RANDARRAY([rows],[columns],[min],[max],[whole_number])

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

=ISBLANK(value)

Return a custom result when a formula generates a #N/A error

=IFNA(value, value_if_na)

Return the largest value in a range of values

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

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

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

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

Returns the character specified by a number

CHAR(number)

Return the logical value TRUE for any error type except the #N/A error.

=ISERR(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)

Return a list of unique values in an array or range

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

Return TRUE or FALSE statements based on testing multiple logical conditions

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