Excel, Sheets

RANK

LEFT, RIGHT

LEN, SEARCH

WEEKDAY

​DATEDIF​

NOW

IF

IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))

OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)

​COUNTIF(range, criterion)​

​SUMIF(range, criterion, sum_range)​

​AVERAGEIF(range, criterion, average_range)​

​VLOOKUP(search_key, range, index, is_sorted)​

​HLOOKUP(search_key, range, index, is_sorted)​

​SUMPRODUCT(array1, [array2, ...])​

RANK

LEFT, RIGHT

LEN, SEARCH

WEEKDAY

​DATEDIF​

NOW

IF

IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))

OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)

​COUNTIF(range, criterion)​

​SUMIF(range, criterion, sum_range)​

​AVERAGEIF(range, criterion, average_range)​

​VLOOKUP(search_key, range, index, is_sorted)​

​HLOOKUP(search_key, range, index, is_sorted)​

​SUMPRODUCT(array1, [array2, ...])​

RANK

LEFT, RIGHT

LEN, SEARCH

WEEKDAY

​DATEDIF​

NOW

IF

IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))

OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)

​COUNTIF(range, criterion)​

​SUMIF(range, criterion, sum_range)​

​AVERAGEIF(range, criterion, average_range)​

​VLOOKUP(search_key, range, index, is_sorted)​

​HLOOKUP(search_key, range, index, is_sorted)​

​SUMPRODUCT(array1, [array2, ...])​