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

Return the serial number of the current date

=TODAY()

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

=ISLOGICAL(value)

Return the rank of a number in a data set

=RANK(number,ref,[order])

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

AVERAGEIF(range, criteria, [average_range])

Return the logical value TRUE if the cell contains any text.

=ISTEXT(value)

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

SUMIF(range,criteria,[sum range])

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

=IFNA(value, value_if_na)

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)

Format numbers as text by applying format codes.

TEXT(value, format_text)

Round a number down to a specified number of digits

=ROUNDDOWN(number, num_digits)

Return the year, month or day component of a date

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

Sum (add) values together.

=SUM(number1,number2,…)

Returns the character specified by a number

CHAR(number)

Return a filtered range of data based on defined criteria

=FILTER (array, include, [if_empty])

Return TRUE or FALSE statements based on testing multiple logical conditions

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

Count the number of characters in a string

LEN(text)