DEGREES
DEGREES(angle) turns radians into degrees: =DEGREES(PI()) is 180. Worked examples, the RADIANS inverse, and why trigonometry hands you radians. Matches Excel.
Syntax
DEGREES(angle)| Argument | Required | Description |
|---|---|---|
angle | Required | An angle in radians. |
Examples
Every example below was executed against VisiGrid engine 0.54.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=DEGREES(PI()) | 180 | |
=DEGREES(1) | 57.30 | One radian is about 57.3 degrees. |
=DEGREES(ATAN2(1,1)) | 45 | The usual place to use it — turning an inverse trig result into something readable. |
Where it belongs
Trigonometric functions take and return radians. DEGREES is the last step of a
formula that ends with ASIN,
ACOS, ATAN or
ATAN2, converting their answer into the units people
expect to read. Its opposite, RADIANS, belongs at the
start of a formula, on the way in.
It is exactly angle*180/PI(); the function name just makes the intent obvious.
Excel compatibility
Matches Excel.