Lookup values in vertical or horizontal ranges

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Round a number down to a specified number of digits

=ROUNDDOWN(number, num_digits)

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

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

Return the number of days between two dates

=DAYS(end_date,start_date)

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

=IFNA(value, value_if_na)

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

=ISERR(value)

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

=ISNUMBER(value)

Calculate the average of numbers in a range that meet specific criteria.

AVERAGEIF(range, criteria, [average_range])

Return the rank of a number in a data set

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

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

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

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)

Lookup values by column in a horizontal table or range

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

Returns the character specified by a number

CHAR(number)

Returns the median or middle number in a data set.

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

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

=ISREF(value)

Return the serial number of the current date

=TODAY()