Can you do inverse trigenometry on excel - i.e Tan-1
 

Can you do inverse trigenometry on excel - i.e Tan-1
 

yes there are loads of trig functions just look under functions in your
formula part and math and trig, but remember they are in radians not
degrees

to convert degrees into radians x PI()/180 but i am sure you know that

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=560016

Can you do inverse trigenometry on excel - i.e Tan-1
 

=DEGREES(ATAN(A1))...returns the angle, in degrees, whose tan is the
value in A1

=ATAN(A1)...returns the angle, in radians, whose tan is the value in A1

Ken Johnson