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.