Convert radians to degrees in Excel for trig functions

Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
5 replies · 2K views
drizzle
Gold Member
Messages
202
Reaction score
58
:blushing:

using excel (vista) how can I reverse the number to be in degrees rather than radians if I want to use trigonometric functions? I have to reverse the number of the angle in radian to use those functions and I want them to be in degrees, anyone know how, thanks in advance.
 
Physics news on Phys.org
=RADIANS (Angle)
=DEGREES(Angle)
 
thanks mgb_phys, but I have this data of angles [in degrees], and I want to calculate cos/sin of these angles, and I have to convert them to radians in order to get the trigonometric functions correctly, i.e.
if I type in a cell [=sin(90)] I get this value [0.893997], while [=sin(radians(90))] would give the correct answer which is 1, does it have to be in radians to get those functions correct? is it not possible to have these function in the form of [sin(number in degrees)]?

[I know they would give the same results, but I want them to be in degrees]
 
Yes you have to do =sin(radians(90))
 
You could just divide the angle in degrees by 57.29577951 to convert to radians.
 
You'll find most software, along with computer languages use radians. Might as well get used to it.