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

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

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

Count the number of characters in a string

LEN(text)

Return the largest value in a range of values

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

Return the rank of a number in a data set

=RANK(number,ref,[order])

Round a number down to the next multiple

=FLOOR(number, significance)

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

REPLACE(old_text, start_num, num_chars, new_text)

Return the smallest value in a range of values

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

Count values in a range that meet multiple specific criteria.

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

Count values in a range that meet a single criteria.

COUNTIF(range,criteria)

Return the relative position of a specified item in a range

=MATCH(lookup_value, lookup_array, [match_type])

Lookup values by row in a vertical table or range

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Count how many numbers are in a list of arguments

COUNT(value1, [value2], ...)

Return the relative position of a specified item in a range

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

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

=ISNUMBER(value)