| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change radians - degrees setting
How do I change setting for trigonomic functions, radians - degrees.
I am making a table with many different trig functions, the answers are currently in radians, I need degrees. Using Excel 2003. Thanks. |
|
#2
|
|||
|
|||
|
All of Excel's trig functions use radians, not degrees, and there
is no way to change that. You can use the DEGREES function to convert radians to degrees. E.g., =DEGREES(ASIN(1)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "David" wrote in message ... How do I change setting for trigonomic functions, radians - degrees. I am making a table with many different trig functions, the answers are currently in radians, I need degrees. Using Excel 2003. Thanks. |
|
#3
|
|||
|
|||
|
OK, thanks for replying.
David. "Chip Pearson" wrote: All of Excel's trig functions use radians, not degrees, and there is no way to change that. You can use the DEGREES function to convert radians to degrees. E.g., =DEGREES(ASIN(1)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "David" wrote in message ... How do I change setting for trigonomic functions, radians - degrees. I am making a table with many different trig functions, the answers are currently in radians, I need degrees. Using Excel 2003. Thanks. |
|
#4
|
|||
|
|||
|
I should have added that you can use the RADIANS function to
convert radians to degrees. E.g., =SIN(RADIANS(45)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... All of Excel's trig functions use radians, not degrees, and there is no way to change that. You can use the DEGREES function to convert radians to degrees. E.g., =DEGREES(ASIN(1)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "David" wrote in message ... How do I change setting for trigonomic functions, radians - degrees. I am making a table with many different trig functions, the answers are currently in radians, I need degrees. Using Excel 2003. Thanks. |
|
#5
|
|||
|
|||
|
"David" wrote in message ... How do I change setting for trigonomic functions, radians - degrees. I am making a table with many different trig functions, the answers are currently in radians, I need degrees. Using Excel 2003. Thanks. I think the best way around this would be to create user defined functions like DSIN, DCOS, DTAN that internally converts from degrees to radians. /Fredrik |
|
#6
|
|||
|
|||
|
Thanks for the replies - I have added some hidden columns with radian /
degrees conversion. "Fredrik Wahlgren" wrote: "David" wrote in message ... How do I change setting for trigonomic functions, radians - degrees. I am making a table with many different trig functions, the answers are currently in radians, I need degrees. Using Excel 2003. Thanks. I think the best way around this would be to create user defined functions like DSIN, DCOS, DTAN that internally converts from degrees to radians. /Fredrik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
| how to change radians to degrees in Excel 2003? | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Linear Mode
