Excel Math/Trigonometry Functions

Excel HOUR Function

This post will guide you how to use Excel HOUR function with syntax and examples in Microsoft excel. Description The Excel HOUR function returns the hour of a time value. Or returns an integer value that represent the hour component of a given time. And the return value is between 0-23. For example, if you… read more »

Excel COMBINA Function

This post will guide you how to use Excel COMBINA function with syntax and examples in Microsoft excel. Description The Excel COMBINA function returns the number of combinations for a given number of items and it includes repetitions. So you can use the COMBINA function to calculate the number of combinations for a specified number… read more »

Excel COMBIN Function

This post will guide you how to use Excel COMBIN function with syntax and examples in Microsoft excel. Description The Excel COMBIN function returns the number of combinations for a given number of items. And you can use the COMBIN function to determine the total possible number of groups for a given number of items…. read more »

Excel DEGREES Function

This post will guide you how to use Excel DEGREES function with syntax and examples in Microsoft excel. Description The Excel DEGREES function converts radians into degrees. And it will return a numeric value. For examples, if you pass the PI() function into the DEGREES function as its argument, and it will return 180. The… read more »

Excel EVEN function

This post will guide you how to use Excel EVEN function with syntax and examples in Microsoft excel. Description The Excel EVEN function rounds a given number up to the nearest even integer. So you can use the EVEN function to return the next even integer after rounding a supplied number up. The returned value… read more »

Excel ODD Function

This post will guide you how to use Excel ODD function with syntax and examples in Microsoft excel. Description The Excel ODD function rounds a given number up to the nearest odd integer. So you can use the ODD function to return the next ODD integer after rounding a supplied number up. The returned value… read more »

Excel CEILING.PRECISE Function

This post will guide you how to use Excel CEILING.PRECISE function with syntax and examples in Microsoft excel. Description The Excel CEILING.PRECISE function returns a given number rounded up to the nearest multiple of a given number of significance or returns a number that is rounded up to the nearest integer number. The CEILING.PRECISE function… read more »

Excel CEILING Function

This post will guide you how to use Excel CEILING function with syntax and examples in Microsoft excel. Description The Excel CEILING function returns a given number rounded up to the nearest multiple of a given number of significance. So you can use the CEILING function to round up a number to the nearest multiple… read more »

Excel RANDBETWEEN Function

This post will guide you how to use Excel RANDBETWEEN function with syntax and examples in Microsoft excel. Description The Excel RANDBETWEEN function returns a random integer number that is between the numbers you specify. Each time when the worksheet is calculated or opened, a new random integer number is generated. So you can use… read more »

Excel ROUNDDOWN Function

Excel CEILING Function The Excel CEILING function returns a given number rounded up to the nearest multiple of a given number of significance. The syntax of the CEILING function is as below:= CEILING (number, significance)…This post will guide you how to use Excel ROUNDDOWN function with syntax and examples in Microsoft excel. Description The Excel… read more »

Excel ROUND Function

This post will guide you how to use Excel ROUND function with syntax and examples in Microsoft excel. Description The Excel ROUND function rounds a number to a specified number of digits. You can use the ROUND function to round to the left or right of the decimal point in Excel. The ROUND function is… read more »

Excel RADIANS Function

This post will guide you how to use Excel RADIANS function with syntax and examples in Microsoft excel. Description The Excel RADIANS function converts degrees into radians in Excel. The RADIANS function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function. The RADIANS function is available in… read more »

Excel RAND Function

This post will guide you how to use Excel RAND function with syntax and examples in Microsoft excel. Description The Excel RAND function returns a random real number that is greater than or equal to 0 and less than 1. The RAND function is returned a new random real number when a worksheet is changed…. read more »

Excel COSH Function

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

Excel COS Function

This post will guide you how to use Excel COS function with syntax and examples in Microsoft excel. Description The Excel COS function returns the cosine of a given angle. If you want to supply an angle to COS function in degrees, then you need to multiply the angle by PI()/180. Or you can use… read more »

Excel EXP Function

This post will guide you how to use Excel EXP function with syntax and examples in Microsoft excel. Description The Excel EXP function returns e raised to the power of a number.  The constant e is equal to 2.71828182845904, and it is the base of the natural logarithm. So you can use EXP function to… read more »

Excel POWER Function

This post will guide you how to use Excel POWER function with syntax and examples in Microsoft excel. Description The Excel POWER function returns the result of a number raised to a given power. So you can use the POWER function to calculate a given number raised to a supplied power in Excel. The POWER… read more »

Excel INT Function

This post will guide you how to use Excel INT function with syntax and examples in Microsoft excel. Description The Excel INT function returns the integer portion of a given number. And it will rounds a given number down to the nearest integer.  And the INT function rounds down, so if you provide a negative… read more »

Excel SINH Function

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

Excel SIN Function

This post will guide you how to use Excel SIN function with syntax and examples in Microsoft excel. Description The Excel SIN function returns the sine of a given angle. If you want to supply an angle to SIN function in degrees, then you need to multiply the angle by PI()/180. Or you can use… read more »

Sidebar