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 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 absolute value of a number

=ABS(number)

Return the serial number of the current date

=TODAY()

Sum (add) values together.

=SUM(number1,number2,…)

Return the year, month or day component of a date

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

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

SUMIF(range,criteria,[sum range])

Count how many values are in a list of arguments

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

Return the k-th smallest value in a range

SMALL(array, k)

Return a random number between 0 and 1

=RAND()

Return TRUE or FALSE statements based on testing multiple logical conditions

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

Count how many numbers are in a list of arguments

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

Round a number up to a specified number of digits

=ROUNDUP(number, num_digits)

Round a number up to the next multiple

=CEILING(number, significance)