Converts degrees to radians. Multiply degrees by π/180 (approximately 0.01745329). Essential for trigonometric calculations, geometry, physics, engineering, and when working with angles in different measurement systems.
Master the fundamentals of Excel RADIANS function
The RADIANS function converts angles from degrees to radians. The conversion factor is π/180 (approximately 0.01745329). This is essential when working with trigonometric functions (SIN, COS, TAN) which use radians, or when converting between measurement systems. Key conversions: 180° = π radians, 90° = π/2, 60° = π/3, 45° = π/4, 30° = π/6. RADIANS preserves the sign of the angle (negative degrees → negative radians).
Multiplies by π/180
Negative degrees → negative radians
180° = π, 90° = π/2
Inverse of DEGREES function
Function-specific parameters
Function-specific return type
Convert angles for SIN, COS, TAN
Angle measurements and calculations
Angle conversions in calculations
Converting between measurement systems
Exact matching required
Returns numeric position
Handles missing text gracefully
=RADIANS(angle)The angle in degrees that you want to convert to radians.
The angle in radians
Description: Converts degrees to radians
Convert 180 degrees to radians
Converts 180 degrees to π radians. RADIANS(180) = 180 × (π/180) = π. This is the fundamental conversion: 180° = π radians.
Use RADIANS function in VBA
' Basic RADIANS in VBA
Range("C1").Value = Application.WorksheetFunction.Radians(180)
' Returns: 3.14159 (π)
' Convert degrees to radians
Sub ConvertDegreesToRadians()
Dim degrees As Double
degrees = Range("A1").Value
Dim radians As Double
radians = Application.WorksheetFunction.Radians(degrees)
Range("B1").Value = radians
End Sub
' Convert multiple angles
Sub ConvertMultipleAngles()
Dim i As Integer
For i = 1 To 10
Dim degrees As Double
degrees = Range("A" & i).Value
Dim radians As Double
radians = Application.WorksheetFunction.Radians(degrees)
Range("B" & i).Value = radians
Next i
End Sub
' Convert for trigonometry
Sub ConvertForTrigonometry()
Dim degrees As Double
degrees = Range("A1").Value
Dim radians As Double
radians = Application.WorksheetFunction.Radians(degrees)
Dim sinValue As Double
sinValue = Application.WorksheetFunction.Sin(radians)
Range("B1").Value = sinValue
End SubConvert angles for SIN, COS, TAN functions
Angle measurements and geometric calculations
Angle conversions in physics calculations
Converting between measurement systems
Non-numeric input in RADIANS
=RADIANS(VALUE(A1))Solution: Ensure input is numeric. RADIANS requires a number. Check for text, errors, or empty cells. Use VALUE() if needed.
Confusion between degrees and radians
Use DEGREES() to convert radians→degreesSolution: RADIANS converts FROM degrees TO radians. If you have radians and need degrees, use DEGREES() instead. Remember: 180° = π rad.
Small rounding differences
=ROUND(RADIANS(A1), 4)Solution: Use known conversions: RADIANS(180) = π. For display, use ROUND: ROUND(RADIANS(angle), decimals).
Confusion about RADIANS vs DEGREES
RADIANS converts degrees→radiansSolution: RADIANS and DEGREES are inverse: RADIANS(DEGREES(x)) = x and DEGREES(RADIANS(x)) = x. Use RADIANS when you have degrees.