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

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

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