Return the logical value TRUE if the cell contains any text.

=ISTEXT(value)

Count values in a range that meet multiple specific criteria.

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

Count the number of characters in a string

LEN(text)

Return the year, month or day component of a date

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

Round a number down to a specified number of digits

=ROUNDDOWN(number, num_digits)

Return the k-th smallest value in a range

SMALL(array, k)

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

REPLACE(old_text, start_num, num_chars, new_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])

Round a number down to the next multiple

=FLOOR(number, significance)

Return the reverse of TRUE or FALSE statements based on testing logical conditions

=NOT(logical)

Returns the arithmetic mean or average of a data set.

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

Lookup values by column in a horizontal table or range

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

Convert text into lowercase, uppercase or capitalize the first letter in a string.

LOWER(text), UPPER(text), PROPER(text)

Round a number up to the next multiple

=CEILING(number, significance)