Is it possibele to calculate in DEGREES not in radians

X

Xplicit2083

Hi, i'm new to this forum
i hope that you can help me with my problem:

for example: if i write a function

SIN(30)

it is suposed to be 0.5 in degrees, but becouse excel calculates in
radians i have to write SIN((PI()/180)*30)

Is it possibele to calculate by defoult in DEGREES not in radians
 
J

Jerry W. Lewis

No, but you are working with radians the hard way; use

=SIN(RADIANS(30))

and

=DEGREES(ASIN(0.5))

Jerry
 
J

jaf

Hi,
You could wrap the calculation in a new function.
=Sine(30)

Function Sine(num as double) 'note: Sine not sin
sine=application.worksheetfunction.sin((pi()/180)*num)
end function
 

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