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!

 

[erik.van.geit]

Hello, CoolSnaz,

would this help you a bit ?

Map3
	A	B	C	D
1	0	0	0
2	15	0,25881905	15
3	30	0,5	30
4	45	0,70710678	45
5	60	0,8660254	60
6	75	0,96592583	75
7	90	1	90
8	105	0,96592583	75
9	120	0,8660254	60
10	135	0,70710678	45
11	150	0,5	30
12	165	0,25881905	15
13	180	1,2251E-16	7E-15	Floating-point arithmetic Excel error
14	195	-0,25881905	-15
15	210	-0,5	-30
16	225	-0,70710678	-45
17	240	-0,8660254	-60
18	255	-0,96592583	-75
19	270	-1	-90
20	285	-0,96592583	-75
21	300	-0,8660254	-60
22	315	-0,70710678	-45
23	330	-0,5	-30
24	345	-0,25881905	-15
25	360	-2,4503E-16	-1E-14	Floating-point arithmetic Excel error
Blad1

kind regards,
Erik

 

[mortgageman]

coolsnaz said:

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!


This is sorta confusing. The sin function takes as an argument something in degrees (or radians). That is not what it returns. For example sin(30 degress)=sin(pi/6 radians)=1/2

Do you mean arcsin?

Gene Klein

 

[erik.van.geit]

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

first of all running the sin function should alwyes give an answer between -1 and 1: the answer is never in degrees nor radians
therefore I thought you meant the acrsin function

=SIN(10) will return the sinus of 10 radians

would another example clarify more ?
formula C1 to C6
=SIN(A1)
=SIN(RADIANS(A1))
=SIN(A3)
=SIN(RADIANS(B3))
=SIN(A5)
=SIN(RADIANS(B5))

Map3.xls
	A	B	C	D
1	30		-0,98803
2			0,5
3	0,017453	1	0,017452
4			0,017452
5	0,523599	30	0,5
6			0,5
Blad1

kind regards,
Erik

 

[CoolSnaz]

Answer

Thanks for all your help, but i have found the answer!

The formula below 'Sin' a figure and gives the answer in degrees!

The A6 represents your input and the rest of the formula is essential to giving the answer in degrees!

'=SIN(A6/(180/PI()))'

Thanks for all your help
CoolSnaz

 

[erik.van.geit]

your formula is the same as
=SIN(RADIANS(A6))

 

[CoolSnaz]

Sorry, i didn't notice that!

Thanks!

 

[erik.van.geit]

=SIN(A1)
=SIN(RADIANS(A1))
=SIN(A3)
=SIN(RADIANS(B3))
=SIN(A5)
=SIN(RADIANS(B5))

but I think you saw them now, isn't it ?

God bless you,
Erik

 

[mortgageman]

The formula below 'Sin' a figure and gives the answer in degrees!

The A6 represents your input and the rest of the formula is essential to giving the answer in degrees!

'=SIN(A6/(180/PI()))'

I don't want to beat a dead horse here, but your formula will not return anything in degrees. Assuming A6 is in degrees, then dividing by 180/pi converts from degrees to radians. Taking the sin will return a UNITLESS number between -1 and 1

Gene Klein

 

[CoolSnaz]

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!