Return the logical value TRUE for any error type.

=ISERROR(value)

Extract characters from the beginning or end of a string.

LEFT(text, [num_chars]), LEFTB(text, [num_bytes])

RIGHT(text, [num_chars]), RIGHTB(text, [num_bytes])

Return the absolute value of a number

=ABS(number)

Return the year, month or day component of a date

=YEAR(serial_number), =MONTH(serial_number), =DAY(serial_number)

Find specific text and its related starting position within a text string.

FIND(find_text, within_text, [start_num])

FINDB(find_text, within_text, [start_num])

Return a filtered range of data based on defined criteria

=FILTER (array, include, [if_empty])

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

=ISREF(value)

Returns the median or middle number in a data set.

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

Count values in a range that meet multiple specific criteria.

COUNTIFS(range1, criteria1, [range2], [criteria2], ...)

Return the rank of a number in a data set

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

Return the largest value in a range of values

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

Return the rank of a number in a data set

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

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

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

Return the k-th smallest value in a range

SMALL(array, k)

Extract characters from within a text string.

MID(text, start_num, num_chars), MIDB(text, start_num, num_bytes)