Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change complete worksheet to degrees
Is there any way to change a worksheet so that all trig functions are expressed in degrees and not radians and I do not have to use the degrees function or use PI/180 or 180/PI individual cells. -- Scrungie ------------------------------------------------------------------------ Scrungie's Profile: http://www.excelforum.com/member.php...o&userid=16030 View this thread: http://www.excelforum.com/showthread...hreadid=466839 |
#2
|
|||
|
|||
I don't think you can do this.
There's no toggle for Degrees/Radians like on your calculator. Scrungie wrote: Is there any way to change a worksheet so that all trig functions are expressed in degrees and not radians and I do not have to use the degrees function or use PI/180 or 180/PI individual cells. -- Scrungie ------------------------------------------------------------------------ Scrungie's Profile: http://www.excelforum.com/member.php...o&userid=16030 View this thread: http://www.excelforum.com/showthread...hreadid=466839 -- Dave Peterson |
#3
|
|||
|
|||
Yes, but only in a limited number of circumstances
if your formulae are as simple as: =sin(A1) then use find =sin( and replace with =sin(3.1415926/180* WARNING this will not work with an arbitrary expression in: =sin() -- Gary''s Student "Scrungie" wrote: Is there any way to change a worksheet so that all trig functions are expressed in degrees and not radians and I do not have to use the degrees function or use PI/180 or 180/PI individual cells. -- Scrungie ------------------------------------------------------------------------ Scrungie's Profile: http://www.excelforum.com/member.php...o&userid=16030 View this thread: http://www.excelforum.com/showthread...hreadid=466839 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet cell color change | New Users to Excel | |||
how to change radians to degrees in Excel 2003? | Excel Discussion (Misc queries) | |||
change worksheet size | Excel Discussion (Misc queries) | |||
How can I change all the figures on a worksheet by a set %, witho. | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |