functions are readily available under Mathematical category for mathematical calculations. Figure: . Mathematical functions Few mathematical functions are listed below. ABS (Number/Cell Address) Number/ Cell Address is the value whose absolute value is to be calculated.
The absolute value of a number is its value without +/- sign. Example =ABS (- ) returns , =ABS ( ) returns , =ABS ( ) returns . ACOS (Number/Cell Address) This function returns the inverse trigonometric cosine of Number which is in radians. The angle returned is in the range .
to +PI. To return the angle in degrees, use the DEGREES function. Example =ACOS (- ) returns .14159265358979 (PI radians) =DEGREES (ACOS( . )) returns .
The cosine of degrees is . . ACOSH (Number/Cell Address) This function returns the inverse hyperbolic cosine of a Number. The Number must be greater than or equal to + .
. Example =ACOSH( ) returns , =ACOSH(COSH( )) returns . ACOT(Number/Cell Address) This function returns the inverse trigonometric cotangent of a Number. Where the angle is in radians is Number.
The angle returned is in the range . to +PI. To return the angle in degrees, use the DEGREES function. Example =ACOT( ) returns .785398163397448 (PI/ radians).
=DEGREES(ACOT( )) returns . The tangent of degrees is . ASIN (Number/Cell Address) This function returns the inverse trigonometric sine of Number where the angle is in radians. The angle returned is in the range -PI/ to +PI/ .
To return the angle in degrees, use the DEGREES function. Example =ASIN ( ) returns . =ASIN ( ) returns .5707963267949 (PI/ radians). =DEGREES (ASIN ( .
)) returns . The sine of degrees is . . ATAN (Number/Cell Address) This function returns the inverse trigonometric tangent of Number where the angle is in radians.
The angle returned is in the range -PI/ to +PI/ . To return the angle in degrees, use the DEGREES function. Example =ATAN ( ) returns .785398163397448 (PI/ radians). =DEGREES (ATAN ( )) returns .
The tangent of degrees is . CEILING (Number; Significance; Mode) This function rounds a number up to the nearest multiple of Significance. Number is the number that is to be rounded up. Significance is the