Microsoft Office Tutorials and References
In Depth Information
SINH
SIN The SINH function returns the hyperbolic sine of a number.
=SINH(number)
SINH(n) is equivalent to (EXP(n)-EXP(-n))/2 .
For example: SINH(3) equals 10.0179 .
The NUMBER argument is any real number.
NUMBER
SQR The SQRT function returns a positive square root.
=SQRT(number)
Notice the example in Figure 10.23. The SQRT function can be used to return the positive
square root of a number or in conjunction with the cosine and radians to return the length of
an unknown where the square root of 64 is 8, as shown.
The NUMBER argument is the number for which you want the
square root. If number is negative, SQRT returns an error value.
NUMBER
Figure 10.23
The SQRT function can
be used to return the
positive square root of
a number or in
conjunction with the cosine
and radians to return
the length of an
unknown.
SQRTPI
The SQRTPI function returns the square root of (number * pi).
=SQRTPI(number)
This function is available from the Analysis ToolPak under Tools, Add-Ins in the menu if
the box for that add-in is checked. If it is not in the add-in list, run Setup to install it. For
example: SQRTPI(10) equals 5.6050 .
NUMBER
The NUMBER argument is the number by which pi is multiplied. If the
number argument is < 0, SQRTPI returns an error value.
Search JabSto ::




Custom Search