Question regarding the "Sin" function

[Bill]

Hi,
Just a quick question regarding the Sin function. When i use the sin
function on my calculator, in degrees mode, it returns a differnet value to
excel.
Say the sin of 30, (in degrees mode) Sin30=0.5 (On my calculator)
the Sin of 30, Sin30=-0.988 (On Excel)

How can i get it return the same value as my calculator?

Thanks in advance.

 

[JE McGimpsey]

XL uses radians. From XL Help ("Sin"):

If your argument is in degrees, multiply it by PI()/180 or use the
RADIANS function to convert it to radians.

So

=SIN(30*PI()/180)

or

=SIN(RADIANS(30))

returns 0.5. This is explained in XL Help.

 

[Stefi]

If 30 degrees is in A1
=SIN(A1*PI()/180)

Regards,
Stefi

„Bill†ezt írta:

 

[Mike]

=SIN(RADIANS(30))

Try this

 

[Bill]

Thats great Mike, thank you very much.

=SIN(RADIANS(30))

Try this

 

[Mike]

Your welcome and thank you for the feedback

Thats great Mike, thank you very much.