Change complete worksheet to degrees

S

Scrungie

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.
 
D

Dave Peterson

I don't think you can do this.

There's no toggle for Degrees/Radians like on your calculator.
 
G

Gary''s Student

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top