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