When would I use DEGREES instead of just storing angles in degrees?

Trigonometric functions in most spreadsheets (SIN, COS, TAN) expect input in radians, not degrees. If your source data comes from sensors, APIs, or scientific calculations using radians, DEGREES lets you convert for human-readable reporting. It bridges the gap between raw computation and end-user display.

Can DEGREES handle very large radian values?

Yes, DEGREES works with any numeric value. A radian value of 100 becomes approximately 5729.58 degrees. However, angles are typically normalized to 0-2π radians (0-360 degrees), so extremely large values are uncommon in fleet maintenance scenarios.

What's the difference between DEGREES and RADIANS?

DEGREES converts radians to degrees (producing a larger number), while RADIANS converts degrees to radians (producing a smaller number). They are inverse functions. Use RADIANS before trigonometric functions, and DEGREES after them to report results in familiar degree measurements.

Do I need DEGREES if I'm just storing wheel alignment data?

Only if your raw sensor data comes in radians. If your system already records alignment angles in degrees, use them directly. DEGREES is specifically needed when converting from radian-based calculations or external APIs like GPS heading data or motion sensor output.

DEGREES function

Converts an angle measured in radians to degrees, making trigonometric or sensor data more readable and interpretable for practical applications.

=DEGREES(angle)

Generate a DEGREES formula

Describe what you need. The generator will reach for DEGREES where DEGREES is the right tool, and tell you when it is not.

Arguments

How DEGREES reads its arguments

Argument	Required	Description
angle	Required	Required. A numeric value representing the angle in radians. Accepts positive, negative, or zero values. Returns #VALUE! if the argument is text or a logical value.

Returns

A number representing the angle measurement in degrees.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Convert a wheel alignment angle from sensor data

Vehicle	Alignment_Angle_Rad
Van-002	0.5236

=DEGREES(F2)

Result: 30

Van-002's wheel alignment sensor recorded 0.5236 radians during its last service. DEGREES converts this to 30 degrees, matching standard wheel alignment specifications. This makes it straightforward for technicians to verify the measurement against expected values.

2. Create a degree column for all vehicles in the maintenance log

Vehicle	Alignment_Angle_Rad	Alignment_Deg
Truck-001	0.2618	=DEGREES(B2)
Van-002	0.5236	=DEGREES(B3)
Car-003	0.7854	=DEGREES(B4)
Truck-004	1.5708	=DEGREES(B5)

=DEGREES(F2:F5)

Result: [15, 30, 45, 90]

Applying DEGREES to the Alignment_Angle_Rad column converts all sensor readings at once. The resulting values (15°, 30°, 45°, 90°) are immediately recognizable to maintenance staff and can be compared against specification ranges for each vehicle type.

3. Round converted angles for a maintenance report

Service_Date	Alignment_Angle_Rad
2024-01-16	0.5236

=ROUND(DEGREES(F3),0)

Result: 30

When preparing maintenance reports, precision can often be limited to whole degrees. ROUND(DEGREES(F3),0) removes decimals, producing clean values like 30 instead of 29.9999. This improves readability in printed reports or client communications.

Common errors

Which DEGREES error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	The angle argument contains text, such as "0.5236 rad" or "π" instead of a pure numeric value.	Extract only the numeric portion of the angle. Use VALUE() to convert text numbers, or reference a cell containing only the number without units or descriptions.
#NAME?	The function name is misspelled, such as =DEGRESS(angle) or =DEGREE(angle) instead of DEGREES.	Verify the function name is spelled exactly as DEGREES with no extra or missing letters.
#REF!	The cell reference to the angle no longer exists, such as =DEGREES(F10) but column F was deleted or the row was removed.	Update the formula to reference the correct cell containing the angle value, or restore the deleted column/row.

Tips and when to use something else

Pair DEGREES with ROUND to produce clean, readable values: =ROUND(DEGREES(angle), 0) for whole degrees.
DEGREES is the inverse of RADIANS — use RADIANS to convert degrees to radians before passing to trigonometric functions like SIN, COS, or TAN.
If your source data is already in degrees, skip DEGREES entirely and use the values directly to avoid unnecessary conversion.
For negative angles, DEGREES preserves the sign: DEGREES(-1.5708) returns -90. Use ABS if you need the absolute magnitude regardless of direction.

Related functions

ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).INTINT rounds any number down to the nearest whole integer, always discarding decimal places and rounding toward negative infinity.ABSABS returns the absolute value of any number, removing the sign to show only magnitude, useful for comparing distances regardless of direction.MROUNDMROUND rounds a number to the nearest multiple of a specified value, useful for rounding to standard increments like 5, 10, or 100.

Frequently asked questions

When would I use DEGREES instead of just storing angles in degrees?: Trigonometric functions in most spreadsheets (SIN, COS, TAN) expect input in radians, not degrees. If your source data comes from sensors, APIs, or scientific calculations using radians, DEGREES lets you convert for human-readable reporting. It bridges the gap between raw computation and end-user display.
Can DEGREES handle very large radian values?: Yes, DEGREES works with any numeric value. A radian value of 100 becomes approximately 5729.58 degrees. However, angles are typically normalized to 0-2π radians (0-360 degrees), so extremely large values are uncommon in fleet maintenance scenarios.
What's the difference between DEGREES and RADIANS?: DEGREES converts radians to degrees (producing a larger number), while RADIANS converts degrees to radians (producing a smaller number). They are inverse functions. Use RADIANS before trigonometric functions, and DEGREES after them to report results in familiar degree measurements.
Do I need DEGREES if I'm just storing wheel alignment data?: Only if your raw sensor data comes in radians. If your system already records alignment angles in degrees, use them directly. DEGREES is specifically needed when converting from radian-based calculations or external APIs like GPS heading data or motion sensor output.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17