RADIANS in Zoho Sheet: Convert Degrees into Radians
Convert degree-based angles into radians for SIN, COS and engineering formulas using Zoho Sheet RADIANS with worked examples.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked
Quick answer: =RADIANS(180) represents π radians, approximately 3.141592654. =RADIANS(30) is approximately 0.523598776. Use this function whenever a trigonometric formula requires radians but source data is recorded in degrees.
A full turn is 360 degrees, or 2π radians; therefore a degree value is multiplied by π/180. Negative rotations remain negative, and turns greater than 360 degrees remain larger than 2π after simple conversion. RADIANS converts the unit, not the direction, sign, orientation, or range of an angle. That distinction matters in imported bearing tables and motion data.
Official syntax and argument
=RADIANS(degrees)
| Argument | Required | Meaning |
|---|---|---|
degrees |
Yes | Numeric angle in degrees, entered directly or referenced from a numeric cell. The checked Zoho examples include positive, negative and 360-degree inputs. |
The directly retrieved Zoho RADIANS function page gives =RADIANS(30) → 0.523598776, =RADIANS(-180) → -3.141592654 and =RADIANS(360) → 6.283185307. It does not establish a separate minimum supported Zoho client version or platform matrix.
Step-by-step conversion sheet
Import angles-practice.csv. Column B contains degree values, C contains an independently calculated reference in radians, and D contains a text description. In E2 enter =RADIANS(B2). Fill E2 down through E13 and compare to C. Do not paste a degree value directly into SIN or COS unless you explicitly want to interpret that number as radians.
| Row | B: angle (degrees) | Conversion formula | Expected radians (approximate) |
|---|---|---|---|
| 2 | -180 | =RADIANS(B2) |
-3.141592654 |
| 3 | -90 | =RADIANS(B3) |
-1.570796327 |
| 4 | -45 | =RADIANS(B4) |
-0.785398163 |
| 5 | 0 | =RADIANS(B5) |
0 |
| 6 | 30 | =RADIANS(B6) |
0.523598776 |
| 7 | 45 | =RADIANS(B7) |
0.785398163 |
| 8 | 60 | =RADIANS(B8) |
1.047197551 |
| 9 | 90 | =RADIANS(B9) |
1.570796327 |
| 10 | 120 | =RADIANS(B10) |
2.094395102 |
| 11 | 180 | =RADIANS(B11) |
3.141592654 |
| 12 | 270 | =RADIANS(B12) |
4.71238898 |
| 13 | 360 | =RADIANS(B13) |
6.283185307 |
The reference values use the mathematical conversion B×π/180 and were computed with Python. They do not represent formula execution in Zoho. Display differences in the last decimal place can arise from rounding: numerical results should usually be compared within a tolerance rather than with an exact text match.
Reverse test: type =DEGREES(RADIANS(45)), expected approximately 45. This verifies the dimensional relationship, not the entirety of Zoho’s runtime implementation. For a long column of inputs, use a visible degree label in the header to prevent future editors treating radians as degrees.
Advanced example 1: calculate angular speed from motor RPM
An item turning at 30 revolutions per minute covers 30×360 degrees per minute, or 180 degrees per second. Its angular speed is =RADIANS(30*360/60) radians per second, approximately 3.141592654 rad/s. With RPM in B2, type =RADIANS(B2*360/60). The equivalent =B2*2*PI()/60 can be a useful cross-check.
This model assumes constant rotation and an RPM value measured in revolutions per minute. A negative RPM can encode reverse direction if the input system uses signed rotation; RADIANS preserves that sign rather than applying ABS automatically.
Advanced example 2: map compass headings into east/north components
Suppose a 12-unit displacement heads 30 degrees clockwise from north. Its east component is =12*SIN(RADIANS(30)) = 6 units; its north component is =12*COS(RADIANS(30)) ≈ 10.392304845 units. If bearing is in B2 and distance is C2, enter =C2*SIN(RADIANS(B2)) and =C2*COS(RADIANS(B2)). This differs from a conventional x-axis mathematical angle, where cosine normally supplies the horizontal component. State the angle convention explicitly.
Errors and edge cases
| Problem | Fix or interpretation |
|---|---|
#VALUE! |
Zoho’s error guide associates this with an invalid argument type. Inspect imported strings such as 30°, and store degrees as numeric values with units in a separate header. |
#NAME! |
Check the function spelling RADIANS; avoid confusing it with DEGREES. |
| Result seems tiny | =RADIANS(1) is only about 0.017453293 because one degree is a small fraction of a full circle. |
| Result exceeds 2Ï€ | This is valid for a multiple-turn angle such as 720 degrees; conversion itself does not wrap or normalize it. |
| Negative result | Negative angles are supported in official examples; a negative rotation remains negative. |
SIN(RADIANS(90)) is near 1, but SIN(90) is not |
The latter takes 90 as radians. Convert degrees at the point of use. |
| Blank or locale-formatted values | Test the input for being numeric before relying on a conversion. Do not infer undocumented coercion rules from Excel. |
Tip: where a formula chain is difficult to audit, place converted radians in their own column. This makes units explicit and helps detect double conversion before data reaches a chart, bearing model or engineering calculation.
Verified cross-software reference for this function
Microsoft Excel RADIANS documentation confirms the same degrees-to-radians purpose. The numerical identity is shared, while exact parsing, precision and interface availability should be verified separately.
How this compares with Excel and Google Sheets
Microsoft Excel documents related functions with comma-delimited examples in an English-language setting, while the checked Zoho Sheet help uses semicolons where multiple arguments occur. Spreadsheet separators can be affected by application and locale settings; do not blindly paste a formula across products without checking the target editor. Shared mathematics does not prove that all data-type coercion, numerical precision, errors, locales, or desktop/mobile support are identical. Where a relevant Microsoft help page is linked below, it establishes only the Excel behaviour specifically described there. Google Sheets may offer the same named function, but that name alone is not a native Zoho compatibility test.
Official reference and verification
Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.
- No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.