Syntax. DEGREES(angle)
Definition. This function converts radians into degrees.
Argument
angle (required) The angle that you want to convert, in radians
Background. Angles are measured in degrees (°). A full circle has 360°. A degree is divided in 60 (angular) minutes (’), and a minute is divided in 60 (angular) seconds (’’).
For certain math and physics operations, an angle is also specified in radians. A full circle is 2π and the angle π is 180°.
In Excel, this function is important because all angle functions use radians (see Figure 16-14), and the results have to be converted into degrees (see the ACOS() and ASIN() functions).
Examples. For circles, the results are returned as radians (see the ATAN() and ATAN2() functions). The DEGREES() function converts the result into degrees:
=DEGREES(ACOS(7.5/15))
More examples for this function are:
=DEGREES(1)
returns 57.296
.
=DEGREES(0.785)
returns 45
.
=DEGREES(1.571)
returns 90
.
Sample Files
Use the SIN_COS worksheet in the Chapter16.xls or Chapter16.xlsx sample file. The sample files are found in the Chapter16 folder. For more information about the sample files, see the section titled Using the Sample Files.
18.118.2.225