Excel Math/Trigonometry Functions

Excel ASINH Function

This post will guide you how to use Excel ASINH function with syntax and examples in Microsoft excel. Description The Excel ASINH function returns the inverse hyperbolic sine of a number. The ASINH function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function. The ASINH function is available in… read more »

Excel FACT Function

This post will guide you how to use Excel FACT function with syntax and examples in Microsoft excel. Description The Excel FACT function returns the factorial of a given number.  The factorial of a given number is equal to 1*2*3…* number. The FACT function is a build-in function in Microsoft Excel and it is categorized… read more »

Excel LN Function

This post will guide you how to use Excel LN function with syntax and examples in Microsoft excel. Description The Excel LN function returns the natural logarithm of a given number.  And the natural logarithms are based on the constant e (the value is equal to 2.718281828…). The LN function is a build-in function in… read more »

Excel LOG Function

This post will guide you how to use Excel LOG function with syntax and examples in Microsoft excel. Description The Excel LOG function returns the logarithm of a given number based on a supplied base. And the default base argument is 10. The LOG function is a build-in function in Microsoft Excel and it is… read more »

Excel LOG10 Function

This post will guide you how to use Excel LOG10 function with syntax and examples in Microsoft excel. Description The Excel LOG10 function returns the base-10 logarithm of a given number. The LOG10 function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function. The LOG10 function is… read more »

Excel MOD Function

This post will guide you how to use Excel MOD function with syntax and examples in Microsoft excel. Description The Excel MOD function returns the remainder of two numbers after division. So you can use the MOD function to get the remainder after a number is divided by a divisor in Excel. And the returned… read more »

Excel MMULT Function

This post will guide you how to use Excel MMULT function with syntax and examples in Microsoft excel. Description The Excel MMULT function returns the matrix product of two arrays. If you want to return multiple result in an array on the worksheet, then you need to input an array formula in the MMULT function…. read more »

Excel MINVERSE Function

This post will guide you how to use Excel MINVERSE function with syntax and examples in Microsoft excel. Description The Excel MINVERSE function returns the inverse matrix for a given matrix. The MINVERSE function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function. The MINVERSE function is… read more »

Excel MDETERM Function

This post will guide you how to use Excel MDETERM function with syntax and examples in Microsoft excel. Description The Excel MDETERM function returns the matrix determinant of an array. So you can use the MDETERM function to calculate the determinant of a square matrix in Excel. The MDETERM function is a build-in function in… read more »

Excel PRODUCT Function

This post will guide you how to use Excel PRODUCT function with syntax and examples in Microsoft excel. Description The Excel PRODUCT function multiplies the numbers and returns the product. For example, If you want to multiple the numbers in both A1 and A2 cells, and you can use the PRODUCT function to create an… read more »

Excel SQRT Function

This post will guide you how to use Excel SQRT function with syntax and examples in Microsoft excel. Description The Excel SQRT function returns the square root of a positive number. And if you provide a negative number, the function will return #NUM! Error. The SQRT function is a build-in function in Microsoft Excel and… read more »

Excel SIGN Function

This post will guide you how to use Excel SIGN function with syntax and examples in Microsoft excel. Description The Excel SIGN function returns the sign of a number. If the number is negative, then the SIGN function will return -1. If the number is equal to 0, then the SIGN function will return 0,… read more »

Excel ROMAN Function

This post will guide you how to use Excel ROMAN function with syntax and examples in Microsoft excel. Description The Excel ROMAN function converts an arabic numeral to roman and the format is Text for returned value. The ROMAN function is a build-in function in Microsoft Excel and it is categorized as a Math and… read more »

Excel SUMX2PY2 Function

This post will guide you how to use Excel SUMX2PY2 function with syntax and examples in Microsoft excel. Description The Excel SUMX2PY2 function returns the sum of the sum of squares of corresponding items in two supplied arrays. So you can use the SUMX2PY2 function to calculate the sum of the sum of squares in the arrays… read more »

Excel SUMXMY2 Function

This post will guide you how to use Excel SUMXMY2 function with syntax and examples in Microsoft excel. Description The Excel SUMXMY2 function returns the sum of the squares of differences between corresponding values in two given arrays and then return the sum of the result. You can use the SUMXMY2 function to calculate the sum of… read more »

Excel SUMX2MY2 Function

This post will guide you how to use Excel SUMX2MY2 function with syntax and examples in Microsoft excel. Description The Excel SUMX2MY2 function returns the sum of the difference of squares between two supplied arrays. The SUMX2MY2 function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function…. read more »

Excel SUMSQ Function

This post will guide you how to use Excel SUMSQ function with syntax and examples in Microsoft excel. Description The Excel SUMSQ function returns the sum of squares of a given set of arguments. The SUMSQ function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function. The… read more »

Excel SUMIFS Function

This post will guide you how to use Excel SUMIFS function with syntax and examples in Microsoft excel. Description The Excel SUMIFS function sum the numbers in the range of cells that meet a single or multiple criteria that you specify. You can use the SUMIFS function to sum cells that based on the dates,… read more »

Excel SUMIF Function

This post will guide you how to use Excel SUMIF function with syntax and examples in Microsoft excel. Description The Excel SUMIF function sum the numbers in the range of cells that meet a single criteria that you specify. You can use the SUMIF function to sum cells that based on the dates, numbers or… read more »

Excel TRUNC Function

This post will guide you how to use Excel TRUNC function with syntax and examples in Microsoft excel. Description The Excel TRUNC function truncates a number to an integer by removing the fractional part of the number. So this function returns a truncated number based on a given number of digits in Excel. The TRUNC… read more »

Sidebar