Degrees and Radians

[CoolSnaz]

Hi All,

I am trying to run the SIN function and excel keeps giving me the answer in Radians.

How make Excel give me the answer in Degrees?

I have tried doing it in Radians and having another field with degrees but it is working through the formula in the wrong order.

any help would be greatly appretiated!

 

[mortgageman]

If you place a figure in a calculator and it is set in degrees it will give you a figure, if you change the calculator to radians it will give a different figure for the same number.

The forula will give you the same figure as when the calculator is set in degrees!

e.g.

Calculator
' Degrees ' 1 = 0.0174524
' Radians ' 1 = 0.8414709

Excel
' =SIN(A6/(180/PI())) ' 1 = 0.0174524
' =SIN(A6) ' 1 = 0.8414709


A6 = 1

I hope this clears things up!

You haven't "cleared anything up", you have just put information on the board that may lead people to do the wrong thing. The sin function takes an angle (which can be expressed in either degrees or radians) and returns a RATIO.
The ratio is the side opposite the angle divided by the hypotnuse. Thus sin (30 deg) = sin (pi/6 radians). If you are getting two different values when you use the sin function in your calculator, you are not plugging in the equivalent value. In other words, pi/6 radians EQUALS 30 degrees. That's why their sin's are equal as well.

If you get two different values for the sin of the same thing, you just have done something wrong.

I hope this clears things up!

Gene Klein

 

[CoolSnaz]

Please ignore all my comments!

I really apologise for any confusion!