How to use the BITAND function

The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]

How to use the BITAND function

The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]

How to use the BIN2OCT function

The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]

How to use the BIN2HEX function

The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]

How to use the BIN2DEC function

The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]

How to use the AVEDEV function

The AVEDEV function calculates the average of the absolute deviations of data points from their mean. The absolute deviation from the […]

How to convert radians to fractions of pi

The formula in cell D3 converts the radian decimal value to fractions of pi. Formula in cell D3: =TEXT(C3/PI(),"?/?")&"*"&CHAR(182) Explaining […]

How to use the ACCRINTM function

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. Formula in cell C7: =ACCRINTM(C2,C3,C4,C5,C6) […]

How to use the ACCRINT function

The ACCRINT function calculates the accrued interest for a security that pays periodic interest. Formula in cell C9: =ACCRINT(C2,C3,C4,C5,C6,C7,C8) Excel […]

Use TYPE to find out what type of data is returned by a function or formula. Formula in cell C3: […]

How to use the TRIMMEAN function

The TRIMMEAN function calculates the mean of the interior of a data set. The function excludes a percentage of data […]

How to use the SERIESSUM function

The SERIESSUM function calculates the sum of a power series based on the following formula: SERIESSUM(x, n, m, a) = […]

How to use the SUMXMY2 function

The SUMXMY2 function calculates the sum of squares of differences of corresponding values in two arrays. Formula in cell F3: […]

How to use the SUMX2PY2 function

The SUMX2PY2 function calculates the sum of the sum of squares of corresponding values in two arrays. The sum of […]

How to use the SUMX2MY2 function

The SUMX2MY2function calculates the sum of the difference of squares of corresponding values in two arrays. Formula in cell F3: […]

How to use the STDEVPA function

The STDEVPA function returns the standard deviation based on the entire population, including text and logical values. The standard deviation […]

How to use the STANDARDIZE function

The STANDARDIZE function calculates a normalized value from a distribution characterized by mean and standard_dev. Formula in cell C5: =STANDARDIZE(C2, […]

How to use the STDEV.S function

The STDEV.S function returns standard deviation based on a sample of the entire population. The standard deviation is how widely […]

How to use the STDEV.P function

The STDEV.P function returns standard deviation based on the entire population. The standard deviation is how widely numbers are distributed […]

How to use the RANK.AVG function

The RANK.AVG function returns the rank of a number in a list of numbers. The number returned indicates its size […]

How to use the QUARTILE.INC function

The QUARTILE.INC function returns the quartile of a data set, based on percentile values from 0..1, inclusive. Use the Quartiles.inc […]

How to use the FLOOR.MATH function

The FLOOR.MATH function rounds a number down to the nearest integer or to the nearest multiple of significance. Formula in […]

How to use the FACTDOUBLE function

The FACTDOUBLE returns the double factorial of a number. Formula in cell C3: =FACTDOUBLE(B3) Excel Function Syntax FACTDOUBLE(number) Arguments number […]

How to use the EXPON.DIST function

The EXPON.DIST function returns the exponential distribution. Use EXPON.DIST to model the time between events. Formula in cell C3: =EXPON.DIST(B3,C3,D3) […]

How to use the EOMONTH function

The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]

How to use the ENCODEURL function

The ENCODEURL function returns a URL-encoded string. Formula in cell C3: =ENCODEURL(B3) Excel Function Syntax ENCODEURL(text) Arguments text Required. The […]

How to use the EFFECT function

The EFFECT function calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding […]