Return the relative position of a specified item in a range

=MATCH(lookup_value, lookup_array, [match_type])

Returns the character specified by a number

CHAR(number)

Return the logical value TRUE if the cell contains either a TRUE or FALSE statement.

=ISLOGICAL(value)

Evaluate and return the contents of a reference specified by a text string

=INDIRECT(ref_text, [a1])

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

SUMIF(range,criteria,[sum range])

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

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Return the number of days between two dates

=DAYS(end_date,start_date)

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

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

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)

Round a number up to a specified number of digits

=ROUNDUP(number, num_digits)

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

=ISNUMBER(value)

Count how many numbers are in a list of arguments

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

Round a number to a specified number of digits

=ROUND(number, num_digits)

Return the most common value in a data set

=MODE.SNGL(number1, [number2], ...)

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

AVERAGEIF(range, criteria, [average_range])

Find specific text and its related starting position within a text string.

FIND(find_text, within_text, [start_num])

FINDB(find_text, within_text, [start_num])

Round a number down to the next multiple

=FLOOR(number, significance)