Microsoft KB Archive/65202

= Works: Trigonometric Functions Return Unexpected Results =

Article ID: 65202

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 for Macintosh
 * Microsoft Works 3.0 for Macintosh
 * Microsoft Works 4.0 for Macintosh
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Excel 3.0 for Macintosh
 * Microsoft Excel 4.0 for Macintosh

-



This article was previously published under Q65202



SUMMARY
When you use the trigonometric functions in a Microsoft Works or Microsoft Excel spreadsheet, the argument will default to radians based on the operating system.

For example, the formula

=cos(60)

will return the result

-.952413

rather than .5.

To return the correct answer to a trigonometric function, multiply

cos

by

pi/180

where  equals the number of degrees.

For example, the formula =cos(60*pi/180) returns the value .5.

Other trigonometric functions that require this same procedure are:

ACOS

ASIN

ATAN

ATAN2

SIN

TAN



MORE INFORMATION
To convert degrees to radians, use the following formula

=*(pi/180)

where  is degrees and  is radians.

Additional query words: 2.00 3.00 4.00 trig wrong mwksss w_works m_works

Keywords: kbinfo KB65202

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.