## Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

# Category: Excel Functions

## MINVERSE function: Description, Usage, Syntax, Examples and Explanation

Examples of MINVERSE function Example 1 Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all the data, if need be.…

## PI function: Description, Usage, Syntax, Examples and Explanation

Example of PI function Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all the data, if need be. Data Radius…

## MUNIT function: Description, Usage, Syntax, Examples and Explanation

What is MUNIT function in Excel? MUNIT function is one of the Math and Trig functions in Microsoft Excel that returns the unit matrix for the specified dimension. Syntax of MUNIT function MUNIT(dimension) The MUNIT function syntax has the following arguments. Dimension: Dimension is an integer specifying the dimension of the unit matrix that you want to return. It returns an…

## MOD function: Description, Usage, Syntax, Examples and Explanation

What is MOD function in Excel? MOD function is one of the Math and Trig functions in Microsoft Excel that returns the remainder after number is divided by divisor. The result has the same sign as divisor. Syntax of MOD function MOD(number, divisor) The MOD function syntax has the following arguments: Number: The number for which you want to find the…

## MULTINOMIAL function: Description, Usage, Syntax, Examples and Explanation

What is MULTINOMIAL function in Excel? MULTINOMIAL function is one of the Math and Trig functions in Microsoft Excel that returns the ratio of the factorial of a sum of values to the product of factorials. Syntax of MULTINOMIAL function MULTINOMIAL(number1, [number2], …) The MULTINOMIAL function syntax has the following arguments: Number1, number2, …    Number1 is required, subsequent numbers are optional. 1…

## MROUND function: Description, Usage, Syntax, Examples and Explanation

What is MROUND function in Excel? MROUND function is one of the Math and Trig functions in Microsoft Excel that returns a number rounded to the desired multiple. Syntax of MROUND function MROUND(number, multiple) The MROUND function syntax has the following arguments: Number: The value to round. Multiple: The multiple to which you want to round number. MROUND formula explanation MROUND…

## ODD function: Description, Usage, Syntax, Examples and Explanation

What is ODD function in Excel? ODD function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up to the nearest odd integer. Syntax of ODD function ODD(number) The ODD function syntax has the following arguments: Number: The value to round. ODD formula explanation If number is nonnumeric, ODD returns the #VALUE! error value. Regardless…

## POWER function: Description, Usage, Syntax, Examples and Explanation

What is POWER function in Excel? POWER function is one of the Math and Trig functions in Microsoft Excel that returns the result of a number raised to a power. Let’s say you want to calculate an extremely small tolerance level for a machined part or the vast distance between two galaxies. To raise a number to a power, use…

## PRODUCT function: Description, Usage, Syntax, Examples and Explanation

What is PRODUCT function in Excel? PRODUCT function is one of the Math and Trig functions in Microsoft Excel that multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using…

## QUOTIENT function: Description, Usage, Syntax, Examples and Explanation

What is QUOTIENT function in Excel? QUOTIENT function is one of the Math and Trig functions in Microsoft Excel that returns the integer portion of a division. Use this function when you want to discard the remainder of a division. Tip: If you want to divide numeric values, you should use the “/” operator as there isn’t a DIVIDE function in…

## RADIANS function: Description, Usage, Syntax, Examples and Explanation

What is RADIANS function in Excel? RADIANS function is one of the Math and Trig functions in Microsoft Excel that converts degrees to radians. Syntax of RADIANS function RADIANS(angle) The RADIANS function syntax has the following arguments: Angle: An angle in degrees that you want to convert. Example of RADIANS function Steps to follow: 1. Open a new Excel worksheet. 2. Copy…

## RAND function: Description, Usage, Syntax, Examples and Explanation

What is RAND function in Excel? RAND function is one of the Math and Trig functions in Microsoft Excel that returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated. Syntax of RAND function RAND() The RAND function syntax has no…

## RANDBETWEEN function: Description, Usage, Syntax, Examples and Explanation

What is RANDBETWEEN function in Excel? RANDBETWEEN function is one of the Math and Trig functions in Microsoft Excel that returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated. Syntax of RANDBETWEEN function RANDBETWEEN(bottom, top) The RANDBETWEEN function syntax has the following arguments: Bottom    Required. The smallest integer…

## ROMAN function: Description, Usage, Syntax, Examples and Explanation

What is ROMAN function in Excel? ROMAN function is one of the Math and Trig functions in Microsoft Excel that converts an arabic numeral to roman, as text. Syntax of ROMAN function ROMAN(number, [form]) The ROMAN function syntax has the following arguments: Number: The Arabic numeral you want converted. Form(Optional): A number specifying the type of roman numeral you want. The…

## ROUND function: Description, Usage, Syntax, Examples and Explanation

What is ROUND function in Excel? ROUND function is one of the Math and Trig functions in Microsoft Excel that rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) The result of this function…

## ROUNDDOWN function: Description, Usage, Syntax, Examples and Explanation

What is ROUNDDOWN function in Excel? ROUNDDOWN function is one of the Math and Trig functions in Microsoft Excel that rounds a number down, toward zero. Syntax of ROUNDDOWN function ROUNDDOWN(number, num_digits) The ROUNDDOWN function syntax has the following arguments: Number: Any real number that you want rounded down. Num_digits: The number of digits to which you want to round number. ROUNDDOWN…

## ROUNDUP function: Description, Usage, Syntax, Examples and Explanation

What is ROUNDUP function in Excel? ROUNDUP function is one of the Math and Trig functions in Microsoft Excel that rounds a number up, away from 0 (zero). Syntax of ROUNDUP function ROUNDUP(number, num_digits) The ROUNDUP function syntax has the following arguments: Number: Any real number that you want rounded up. Num_digits: The number of digits to which you want to…

## SEC function: Description, Usage, Syntax, Examples and Explanation

What is SEC function in Excel? SEC function is one of the Math and Trig functions in Microsoft Excel that returns the secant of an angle. Syntax of SEC function SEC(number) The SEC function syntax has the following arguments. Number: Number is the angle in radians for which you want the secant. SEC formula explanation The absolute value of number must…

## SQRTPI function: Description, Usage, Syntax, Examples and Explanation

What is SQRTPI function in Excel? SQRTPI function is one of the Math and Trig functions in Microsoft Excel that returns the square root of (number * pi). Syntax of SQRTPI function SQRTPI(number) The SQRTPI function syntax has the following arguments: Number: The number by which pi is multiplied. SQRTPI formula explanation If number < 0, SQRTPI returns the #NUM! error…

## SEQUENCE function: Description, Usage, Syntax, Examples and Explanation

What is SEQUENCE function in Excel? SEQUENCE function is one of the Math and Trig functions in Microsoft Excel that allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. Syntax of SEQUENCE function =SEQUENCE(rows, [columns], [start], [step]) Example of SEQUENCE function Example 1 In the following example, we created an array that’s…

## SUMIF function: Description, Usage, Syntax, Examples and Explanation

What is SUMIF function in Excel? SUMIF function is one of the Math and Trig functions in Microsoft Excel that is used to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use…

## SUMIFS function: Description, Usage, Syntax, Examples and Explanation

What is SUMIFS function in Excel? SUMIFS function is one of the Math and Trig functions in Microsoft Excel that adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar…

## SUMPRODUCT function: Description, Usage, Syntax, Examples and Explanation

What is SUMSQ function in Excel? SUMSQ function is one of the Math and Trig functions in Microsoft Excel that multiplies corresponding components in the given arrays, and returns the sum of those products. Syntax of SUMSQ function SUMPRODUCT(array1, [array2], [array3], …) The SUMPRODUCT function syntax has the following arguments: Array1     Required. The first array argument whose components you want to…

## SUMSQ function: Description, Usage, Syntax, Examples and Explanation

What is SUMSQ function in Excel? SUMSQ function is one of the Math and Trig functions in Microsoft Excel that returns the sum of the squares of the arguments. Syntax of SUMSQ function SUMSQ(number1, [number2], …) The SUMSQ function syntax has the following arguments: Number1, number2, …    Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want…

## SUMX2MY2 function: Description, Usage, Syntax, Examples and Explanation

What is SUMX2MY2 function in Excel? SUMX2MY2 function is one of the Math and Trig functions in Microsoft Excel that returns the sum of the difference of squares of corresponding values in two arrays. Syntax of SUMX2MY2 function SUMX2MY2(array_x, array_y) The SUMX2MY2 function syntax has the following arguments: Array_x: The first array or range of values. Array_y: The second array or…

## SUMX2PY2 function: Description, Usage, Syntax, Examples and Explanation

What is SUMX2PY2 function in Excel? SUMX2PY2 function is one of the Math and Trig functions in Microsoft Excel that returns the sum of the sum of squares of corresponding values in two arrays. The sum of the sum of squares is a common term in many statistical calculations. Syntax of SUMX2PY2 function SUMX2PY2(array_x, array_y) The SUMX2PY2 function syntax has the…

## SUMXMY2 function: Description, Usage, Syntax, Examples and Explanation

What is SUMXMY2 function in Excel? SUMXMY2 function is one of the Math and Trig functions in Microsoft Excel that returns the sum of squares of differences of corresponding values in two arrays. Syntax of SUMXMY2 function SUMXMY2(array_x, array_y) The SUMXMY2 function syntax has the following arguments: Array_x: The first array or range of values. Array_y:    Required. The second array…

## TAN function: Description, Usage, Syntax, Examples and Explanation

What is TAN function in Excel? TAN function is one of the Math and Trig functions in Microsoft Excel that returns the tangent of the given angle. Syntax of TAN function TAN(number) The TAN function syntax has the following arguments: Number: The angle in radians for which you want the tangent. TAN formula explanation If your argument is in degrees, multiply…

## TANH function: Description, Usage, Syntax, Examples and Explanation

What is TANH function in Excel? TANH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic tangent of a number. Syntax of TANH function TANH(number) The TANH function syntax has the following arguments: Number: Any real number. TANH formula explanation The formula for the hyperbolic tangent is: Example of TANH function Steps to follow: 1.…

## MMULT function: Description, Usage, Syntax, Examples and Explanation

What is MMULT function in Excel? MMULT function is one of the Math and Trig functions in Microsoft Excel that returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. Syntax of MMULT function MMULT(array1, array2) The MMULT function syntax has the following…

## ABS function: Description, Usage, Syntax, Examples and Explanation

What is ABS function in Excel? ABS function is one of the Math and Trig functions in Microsoft Excel that returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax of ABS function ABS(number) The ABS function syntax has the following arguments: Number: The real number of which you want the…

## SECH function: Description, Usage, Syntax, Examples and Explanation

What is SECH function in Excel? SECH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic secant of an angle. Syntax of SECH function SECH(number) The SECH function syntax has the following arguments. Number: Number is the angle in radians for which you want the hyperbolic secant. SECH formula explanation The absolute value of…

## SERIESSUM function: Description, Usage, Syntax, Examples and Explanation

What is SERIESSUM function in Excel? SERIESSUM function is one of the Math and Trig functions in Microsoft Excel that returns the sum of a power series based on the formula: Many functions can be approximated by a power series expansion. Syntax of SERIESSUM function SERIESSUM(x, n, m, coefficients) The SERIESSUM function syntax has the following arguments: X: The input value…

## SIGN function: Description, Usage, Syntax, Examples and Explanation

What is SIGN function in Excel? SIGN function is one of the Math and Trig functions in Microsoft Excel that determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative. Syntax of SIGN function SIGN(number) The SIGN function syntax has the following arguments: Number:…

## SIN function: Description, Usage, Syntax, Examples and Explanation

What is SIN function in Excel? SIN function is one of the Math and Trig functions in Microsoft Excel that returns the sine of the given angle. Syntax of SIN function SIN(number) The SIN function syntax has the following arguments: Number: The angle in radians for which you want the sine. SIN formula explanation If your argument is in degrees, multiply…

## SINH function: Description, Usage, Syntax, Examples and Explanation

What is SINH function in Excel? SINH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic sine of a number. Syntax of SINH function SINH(number) The SINH function syntax has the following arguments: Number: Any real number. SINH formula explanation The formula for the hyperbolic sine is: Example of SINH function Steps to follow: 1.…

## SQRT function: Description, Usage, Syntax, Examples and Explanation

What is SQRT function in Excel? SQRT function is one of the Math and Trig functions in Microsoft Excel that returns a positive square root. Syntax of SQRT function SQRT(number) The SQRT function syntax has the following arguments: Number: The number for which you want the square root. SQRT formula explanation If number is negative, SQRT returns the #NUM! error value.…

## SUBTOTAL function: Description, Usage, Syntax, Examples and Explanation

What is SUBTOTAL function in Excel? SUBTOTAL function is one of the Math and Trig functions in Microsoft Excel that returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it…

## ACOS function: Description, Usage, Syntax, Examples and Explanation

What is ACOS function in Excel? ACOS function is one of the Math and Trig functions in Microsoft Excel that returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi. Syntax of ACOS function ACOS(number) The ACOS function syntax has…

## ACOSH function: Description, Usage, Syntax, Examples and Explanation

What is ACOSH function in Excel? ACOSH function is one of the Math and Trig functions in Microsoft Excel that returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number. Syntax of ACOSH function ACOSH(number) The ACOSH function syntax…