Round a number up to the next multiple

=CEILING(number, significance)

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

=NOT(logical)

Count how many values are in a list of arguments

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

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)

Return the rank of a number in a data set

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

Round a number down to the next multiple

=FLOOR(number, significance)

Return a random integer number between 2 values

=RANDBETWEEN(bottom,top)

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

=ISERR(value)

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 an array of random decimal or integer numbers between specified values

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

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 TRUE or FALSE statements based on testing multiple logical conditions

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

Return the relative position of a specified item in a range

=MATCH(lookup_value, lookup_array, [match_type])

Return the rank of a number in a data set

=RANK(number,ref,[order])

Count the number of characters in a string

LEN(text)