Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I graph trigonometric functions? | Charts and Charting in Excel | |||
how to use trigonometric functions in Excel? | Excel Worksheet Functions | |||
convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
Trigonometric functions | Excel Worksheet Functions | |||
converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions |