Return TRUE or FALSE statements based on testing multiple logical conditions

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

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

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

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

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

=IFNA(value, value_if_na)

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

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

Remove irregular spacing from either end of or within a text string.

TRIM(text)

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

=INDIRECT(ref_text, [a1])

Return the rank of a number in a data set

=RANK(number,ref,[order])

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

=ISBLANK(value)

Extract characters from the beginning or end of a string.

LEFT(text, [num_chars]), LEFTB(text, [num_bytes])

RIGHT(text, [num_chars]), RIGHTB(text, [num_bytes])

Return a list of unique values in an array or range

=UNIQUE(array,[by_col],[exactly_once])

Return a filtered range of data based on defined criteria

=FILTER (array, include, [if_empty])