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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 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" <[email protected]> wrote in message
news:uwVSA%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>
>
"David" <[email protected]> wrote in message
news:[email protected]...
> 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
Thanks for the replies - I have added some hidden columns with radian /
degrees conversion.
"Fredrik Wahlgren" wrote:
>
> "David" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks