Microsoft Office Tutorials and References

In Depth Information

**SIGN**

The
COEFFICIENT
(or
A
) argument is a set of coefficients by which each successive power of

X
is multiplied. The number of values in coefficients determines the number of terms in the

power series. For example, if there are three values in coefficients, then there will be three

terms in the power series. For example:
=SERIESSUM(2,1,1,{1,2,3})
equals 34.

If any argument is nonnumeric,
SERIESSUM
returns an error value.

SIG
The
SIGN
function determines the sign of a number.

=SIGN(number)

For example:
SIGN(100)
equals 1 and
SIGN(–100)
equals –1.

The
NUMBER
argument is any real number. The
SIGN
function

returns 1 if the number is positive, zero (0) if the number is 0,

and 1 if the number is negative.

NUMBER

SIN
The
SIN
function returns the sine of the given angle.

=SIN(number)

The
SIN
function is useful for determining the lengths and direction of vectors, as illustrated

in Figure 10.22. In this problem, a course correction is needed due to a tailwind. The
SIN

function returns a value from the angle converted to radians that is used in a formula with the

ASIN
function to return the desired result.

The
NUMBER
argument is the angle in radians for which you want

the sine. If your argument is in degrees, multiply it by PI()/180 to

convert it to radians.

NUMBER

Figure 10.22

The
SIN
function is

important in calculating

vectors.