Return the absolute value of a number

=ABS(number)

Lookup values by column in a horizontal table or range

=HLOOKUP (lookup_value, table_array, row_index_num, [range_lookup])

Return the logical value TRUE for any error type.

=ISERROR(value)

Return the rank of a number in a data set

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

Round a number down to a specified number of digits

=ROUNDDOWN(number, num_digits)

Return the relative position of a specified item in a range

=XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

Round a number down to the next multiple

=FLOOR(number, significance)

Return the smallest value in a range of values

MIN(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 the year, month or day component of a date

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

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 a custom result when a formula generates a #N/A error

=IFNA(value, value_if_na)

Format numbers as text by applying format codes.

TEXT(value, format_text)

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

=ISREF(value)

Remove irregular spacing from either end of or within a text string.

TRIM(text)