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

's Computer Specifications

's Computer Specifications

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

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

Regards

Da

--
Da
-----------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...fo&userid=2710
View this thread: http://www.excelforum.com/showthread.php?threadid=56001

's Computer Specifications

=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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I do the inverse of tan in Excel?	=?Utf-8?B?TWlkZGxlRWFydGhOZXQ=?=	Microsoft Excel Worksheet Functions	11	20th Dec 2011 02:14 PM
Inverse tangent in excel, please help!	JurgSpam	Microsoft Excel Worksheet Functions	3	20th Dec 2011 01:58 PM
Inverse Tangent in excel formulae	=?Utf-8?B?S2lyc3R5?=	Microsoft Excel Worksheet Functions	1	31st Jan 2007 11:48 AM
How do I change the inverse colour in an Excel chart?	=?Utf-8?B?ZGF2aWRfaHV0dG9uLk5PX1NQQU0=?=	Microsoft Excel Charting	3	21st Feb 2005 12:16 PM
Inverse tangent - Excel	=?Utf-8?B?c21hcnRhbmRzYXh5?=	Microsoft Excel Setup	2	10th Oct 2004 08:29 PM