Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.
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 …
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, …
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 …
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 …
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, …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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) …
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 …
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 …
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 …
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, …
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, …
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 …
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 …
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 …
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 …
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. …
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 …
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: …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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) …
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 …