Sum (add) values together.

=SUM(number1,number2,…)

Round a number down to the next multiple

=FLOOR(number, significance)

Return a random integer number between 2 values

=RANDBETWEEN(bottom,top)

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 a cell is blank or empty

=ISBLANK(value)

Return the serial number of a particular date

=DATE (year, month, day)

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

Sum (add) values in a range that meet a single criteria.

SUMIF(range,criteria,[sum range])

Return the logical value TRUE for any error type.

=ISERROR(value)

Count how many numbers are in a list of arguments

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

Return the logical value TRUE if a cell contains the #N/A error

=ISBLANK(value)

Return TRUE or FALSE statements based on testing multiple logical conditions

=OR(logical1, [logical2], ...)

Round a number down to a specified number of digits

=ROUNDDOWN(number, num_digits)

Return the serial number of the current date and time

=NOW()

Count how many values are in a list of arguments

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

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

=IFNA(value, value_if_na)

Return the serial number of the current date

=TODAY()