Microsoft KB Archive/41064

= Trigonometric Functions Returning Incorrect Values =

Article ID: 41064

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q41064



SUMMARY
Trigonometric functions in Microsoft Excel calculate the result based on radians, not degrees.

An angle in radians equals /(180/PI) in degrees. The following formula converts degrees into radians, where  is the number of degrees in the angle that is being converted to radians:

= /(180/pi)

For example, to find the sine of a 43-degree angle, use the following formula:

=SIN(43/(180/pi))

Beginning with Excel 4.0, Excel also includes the RADIANS function, which is used as follows:

=RADIANS

=SIN(RADIANS(43))

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.20 3.0 5.0 7.0 98 97 XL

Keywords: KB41064

-

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

© Microsoft Corporation. All rights reserved.