Exceljet

Quick, clean, and to the point

Excel 2010

The functions below were introduced in Excel 2010, and are available in later versions, including Excel 365.

Excel AGGREGATE function

The Excel AGGREGATE function returns a aggregate calculation like AVERAGE, COUNT, MAX, etc., optionally ignoring hidden rows and errors. A total of 19 operations are available, specified by function number in the first argument (see table for...

Excel BINOM.DIST function

The Excel BINOM.DIST function returns the individual term binomial distribution probability. You can use BINOM.DIST to calculate probabilities that an event will occur a certain number of times in a given number of trials.

Excel CEILING.PRECISE function

The Excel CEILING.PRECISE function rounds a number up to a given multiple. Unlike the CEILING function, CEILING.MATH defaults to a multiple of 1, and always rounds negative numbers toward zero.

Excel FLOOR.PRECISE function

The Excel FLOOR.PRECISE function rounds a number down to a specified multiple. Unlike the FLOOR function, FLOOR.PRECISE defaults to a multiple of 1, and always rounds negative numbers away from zero.

Excel MODE.MULT function

The Excel MODE.MULT function returns an array of the most frequently occurring numbers in a numeric data set. For example, =MODE.MULT(1,2,3,3,4,5,5) returns {3;5}, because there are two modes, 3 and 5.

Excel MODE.SNGL function

The Excel MODE.SNGL function returns the most frequently occurring number in a numeric data set. For example, =MODE.SNGL(1,2,4,4,5,5,5,6) returns 5.

Excel NETWORKDAYS.INTL function

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates. NETWORKDAYS.INTL excludes Saturday and Sunday by default, but provides a way to specify which days of the week are considered weekends.  The function can...

Excel NORM.DIST function
The Excel NORM.DIST function returns values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF). The PDF returns values of points on the curve. The CDF returns the area under the curve to the left...
Excel NORM.INV function
The Excel NORM.INV function returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. Given the probability of an event occurring below a threshold value, the function returns the threshold value...
Excel NORM.S.DIST function
The Excel NORM.S.DIST function returns output for the standard normal cumulative distribution (CDF) and the standard normal probability density function (PDF).
Excel NORM.S.INV function
The Excel NORM.S.INV function returns the inverse of the standard normal cumulative distribution.
Excel PERCENTILE.EXC function

The Excel PERCENTILE.EXC function calculates the "kth percentile" for a set of data where k is 0 to 1. A percentile is a value below which a given percentage of values in a data set fall. You can use PERCENTILE.EXC to determine the 90th...

Excel PERCENTILE.INC function

The Excel PERCENTILE.INC function calculates the "kth percentile" for a set of data where k is 0 to 1, inclusive. A percentile is a value below which a given percentage of values in a data set fall. You can use PERCENTILE.INC to determine the...

Excel PERCENTRANK.EXC function

The Excel PERCENTRANK.EXC function returns the relative rank of a value in a data set as a percentage representing how many values are less than or equal to the value. Percentile rank is commonly used as a way to interpret standing in...

Excel PERCENTRANK.INC function

The Excel PERCENTRANK.INC function returns the relative rank of a value in a data set as a percentage representing the number of values less than or equal to the value. Percentile rank is commonly used as a way to interpret standing in...

Excel QUARTILE.EXC function

The Excel QUARTILE.EXC function returns the quartile for a given set of data. QUARTILE.EXC can return, first quartile, second quartile, and third quartile.

Excel QUARTILE.INC function

The Excel QUARTILE.INC function returns the quartile (each of four equal groups) for a given set of data. QUARTILE.INC can return minimum value, first quartile, second quartile, third quartile, and max value. Starting with Excel 2010, the...

Excel RANK.AVG function

The Excel RANK.AVG function returns the rank of a number against a list of other other numeric values. When values contain duplicates, the RANK.AVG function will assign an average rank to each set of duplicates.

Excel RANK.EQ function

The Excel RANK.EQ function returns the rank of a number against a list of other other numeric values. When values contain duplicates, RANK.EQ will assign the higher rank to each set of duplicates.

Excel STDEV.P function

The Excel STDEV.P function calculates the standard deviation for a sample set of data. STDEV.P calculates standard deviation using the "n" method, ignoring logical values and text.

Excel STDEV.S function

The Excel STDEV.S function calculates the standard deviation for a sample set of data. STDEV.S replaces the older STDEV function, with the same behavior.

Excel VAR.P function

The Excel VAR.P function returns the variance in an entire population.  If data represents a sample of the population, use the VAR.S function.

Excel VAR.S function

The Excel VAR.S function returns the variance of a sample. If data represents the entire population, use the VAR.P function. VAR.S ignores text values and logicals in references.

Excel WORKDAY.INTL function

The Excel WORKDAY.INTL function takes a date and returns the nearest working in the future or past, based on an offset value you provide. Unlike the WORKDAY function, WORKDAY.INTL allows...