Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |