ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trigonometric functions in Degrees (https://www.excelbanter.com/excel-discussion-misc-queries/140407-trigonometric-functions-degrees.html)

jfg

Trigonometric functions in Degrees
 
The trigonometric functions atre in radians. How do I take the trigonometric
functins of angles in degrees?

For example, I have 30 in cell A2. In cell B2, I would like to take the
sine(30), where 30 is in degrees.

Thank you.



bj

Trigonometric functions in Degrees
 
=sine(A2*PI()/180)

"jfg" wrote:

The trigonometric functions atre in radians. How do I take the trigonometric
functins of angles in degrees?

For example, I have 30 in cell A2. In cell B2, I would like to take the
sine(30), where 30 is in degrees.

Thank you.



bj

Trigonometric functions in Degrees
 
that should have been
=sin(A2*PI()/180)

"bj" wrote:

=sine(A2*PI()/180)

"jfg" wrote:

The trigonometric functions atre in radians. How do I take the trigonometric
functins of angles in degrees?

For example, I have 30 in cell A2. In cell B2, I would like to take the
sine(30), where 30 is in degrees.

Thank you.



James Silverton

Trigonometric functions in Degrees
 
bj wrote on Wed, 25 Apr 2007 11:28:00 -0700:

b "bj" wrote:

?? =sine(A2*PI()/180)
??
?? "jfg" wrote:
??
?? The trigonometric functions atre in radians. How do I
?? take the trigonometric functins of angles in degrees?
??
?? For example, I have 30 in cell A2. In cell B2, I would
?? like to take the sine(30), where 30 is in degrees.
??
?? Thank you.
??

For completeness, it might be noted that the RADIANS function
exists so that SIN(RADIANS(30)) = 0.5 etc. There is also a
corresponding DEGREES function that can be used to return an
inverse value in degrees, as for example, DEGREES(ASIN(0.5)) =
30.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not


jfg

Trigonometric functions in Degrees
 
Thank you very much, BJ.

"bj" wrote:

that should have been
=sin(A2*PI()/180)

"bj" wrote:

=sine(A2*PI()/180)

"jfg" wrote:

The trigonometric functions atre in radians. How do I take the trigonometric
functins of angles in degrees?

For example, I have 30 in cell A2. In cell B2, I would like to take the
sine(30), where 30 is in degrees.

Thank you.



jfg

Trigonometric functions in Degrees
 
Thank you, James. Your information will definitely come in handy when I am
working with the inverse trigonometric functions.

"James Silverton" wrote:

bj wrote on Wed, 25 Apr 2007 11:28:00 -0700:

b "bj" wrote:

?? =sine(A2*PI()/180)
??
?? "jfg" wrote:
??
?? The trigonometric functions atre in radians. How do I
?? take the trigonometric functins of angles in degrees?
??
?? For example, I have 30 in cell A2. In cell B2, I would
?? like to take the sine(30), where 30 is in degrees.
??
?? Thank you.
??

For completeness, it might be noted that the RADIANS function
exists so that SIN(RADIANS(30)) = 0.5 etc. There is also a
corresponding DEGREES function that can be used to return an
inverse value in degrees, as for example, DEGREES(ASIN(0.5)) =
30.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not




All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com