The OR function

Returns TRUE if any argument is TRUE

LogicalMatthew Di MinnoMarch 23, 2020Comment

The OFFSET function

Returns a reference offset from a given reference

Lookup and referenceMatthew Di MinnoMarch 22, 2020Comment

The NOW function

Returns the serial number of the current date and time

Date and TimeMatthew Di MinnoMarch 21, 2020Comment

The NOT function

Reverses the logic of its argument

LogicalMatthew Di MinnoMarch 20, 2020Comment

The NETWORKDAYS function

Returns the number of whole workdays between two dates

Date and TimeMatthew Di MinnoMarch 19, 2020Comment

The MONTH function

Converts a serial number to a month

Date and TimeMatthew Di MinnoMarch 18, 2020Comment

The MODE.SNGL function

Returns the most common value in a data set

StatisticalMatthew Di MinnoMarch 17, 2020Comment

The MODE.MULT function

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data

StatisticalMatthew Di MinnoMarch 16, 2020Comment

The MINUTE function

Converts a serial number to a minute

Date and TimeMatthew Di MinnoMarch 15, 2020Comment

The MIN function

Returns the minimum value in a list of arguments

StatisticalMatthew Di MinnoMarch 14, 2020Comment

The MID function

Returns a specific number of characters from a text string starting at the position you specify

TextMatthew Di MinnoMarch 13, 2020Comment

The MEDIAN function

Returns the median of the given numbers

StatisticalMatthew Di MinnoMarch 12, 2020Comment

The MAX function

Returns the maximum value in a list of arguments

StatisticalMatthew Di MinnoMarch 11, 2020Comment

The MATCH function

Looks up values in a reference or array

Lookup and referenceMatthew Di MinnoMarch 10, 2020Comment

The LOOKUP function

Looks up values in a vector or array

Lookup and referenceMatthew Di MinnoMarch 9, 2020Comment

The LEN function

Returns the number of characters in a text string

TextMatthew Di MinnoMarch 8, 2020Comment

The LEFT function

Returns the leftmost characters from a text value

TextMatthew Di MinnoMarch 7, 2020Comment

The LARGE function

Returns the k-th largest value in a data set

StatisticalMatthew Di MinnoMarch 6, 2020Comment

The INDEX function

Uses an index to choose a value from a reference or array

Lookup and referenceMatthew Di MinnoMarch 5, 2020Comment

The IFS function

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

LogicalMatthew Di MinnoMarch 4, 2020Comment