How to How to Use RADIANS Function in Excel in Excel - Practical Guide

Learn to convert degrees to radians using the RADIANS function in Excel. This essential trigonometric function transforms angle measurements from degrees (0-360°) into radians (0-2π), enabling accurate calculations in engineering, mathematics, and scientific analysis where radian-based formulas are required.

Why This Matters

RADIANS is critical for engineers, scientists, and analysts who need to work with trigonometric functions like SIN, COS, and TAN, which require radian input rather than degrees.

Prerequisites

•Basic understanding of Excel cell references and formulas
•Knowledge of degrees vs. radians in trigonometry

Step-by-Step Instructions

Open Excel and select a target cell

Launch Microsoft Excel and click on an empty cell where you want the radian result to appear (e.g., cell B2).

Type the RADIANS formula

Enter the formula =RADIANS(angle) where 'angle' is your degree value or cell reference; for example, =RADIANS(180) or =RADIANS(A2).

Press Enter to execute

Press Enter to calculate the conversion; the result will display in the selected cell showing the radian equivalent.

Use result in trigonometric functions

Combine RADIANS with SIN, COS, or TAN functions using syntax like =SIN(RADIANS(90)) to calculate trigonometric values from degree inputs.

Copy formula down for multiple values

Select the cell with your formula, copy it (Ctrl+C), then select a range below and paste (Ctrl+V) to apply RADIANS to multiple degree values at once.

Alternative Methods

Manual conversion using PI function

Use =angle*(PI()/180) instead of RADIANS to convert degrees to radians without the dedicated function.

Direct trigonometric input

Embed RADIANS directly into trigonometric functions like =COS(RADIANS(A1)) for single-step calculation without intermediate cells.

Tips & Tricks

✓180 degrees equals π radians (approximately 3.14159), so test RADIANS(180) to verify accuracy.
✓Always use RADIANS before SIN, COS, or TAN if your angle data is in degrees.
✓Remember that RADIANS returns a decimal number; format cells as Number with sufficient decimal places for precision.

Pro Tips

★Combine RADIANS with ABS() to ensure positive radian values: =ABS(RADIANS(A1)).
★Use named ranges for common angle values (like =RADIANS(FullRotation) where FullRotation=360) to make formulas more readable.
★Nest RADIANS within nested trigonometric functions for complex calculations: =SIN(RADIANS(A1))+COS(RADIANS(B1)).

Troubleshooting

RADIANS returns #NAME? error

This means Excel doesn't recognize the function name; ensure you're using the correct spelling RADIANS (not RADIAN) and that your Excel version supports it.

Result appears as 0 or very small number

Check that your cell is formatted as Number, not Text, and verify the degree input is correct and within expected range (0-360 or -360-360).

SIN or COS result is unexpected after using RADIANS

Confirm your degree value is accurate and that you're using =SIN(RADIANS(degrees)) syntax; calculate manually to verify the expected trigonometric output.

Related Excel Formulas

DEGREES SIN COS TAN ASIN ACOS ATAN PI

Frequently Asked Questions

What is the difference between RADIANS and DEGREES functions?

RADIANS converts degrees to radians, while DEGREES does the opposite—converts radians to degrees. Use RADIANS when preparing angle data for trigonometric functions that require radian input.

Can I use RADIANS with negative degree values?

Yes, RADIANS works with negative values, which represent angles in the opposite direction; for example, =RADIANS(-90) returns -1.5708 radians.

Do I need RADIANS if my data is already in radians?

No, if your angle data is already in radians, do not use RADIANS as it will incorrectly convert them again; apply RADIANS only to degree-based data.

What is the relationship between π and RADIANS?

One full rotation (360°) equals 2π radians; RADIANS uses this relationship to convert by multiplying degrees by π/180 internally.