Return TRUE or FALSE statements based on testing multiple logical conditions

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

Return the smallest value in a range of values

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

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 number of days between two dates

=DAYS(end_date,start_date)

Return the rank of a number in a data set

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

Sum (add) values together.

=SUM(number1,number2,…)

Convert text into lowercase, uppercase or capitalize the first letter in a string.

LOWER(text), UPPER(text), PROPER(text)

Count the number of characters in a string

LEN(text)

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

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

Return the logical value TRUE if the cell contains any value that is not text.

=ISNONTEXT(value)

Format numbers as text by applying format codes.

TEXT(value, format_text)

Round a number up to the next multiple

=CEILING(number, significance)

Returns the arithmetic mean or average of a data set.

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

Return the serial number of the current date and time

=NOW()

Returns a value from a list based on an index number.

=CHOOSE(index_num, value1, [value2], ...)

Return the logical value TRUE if a cell is blank or empty

=ISBLANK(value)

Return a random number between 0 and 1

=RAND()

Repeat a specific text string by a number of instances.

REPT(text, number_times)