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

D

Dav

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
 
K

Ken Johnson

=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
 

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

Similar Threads

Using Degrees in trigonometric functions 1
How do you calculate cotangent in Excel 2003? 1
Trig Function seems odd. 9
Help: Javascript to Excel VBA? 3
I need help entering a fourmula in excel 0
What is fastest for this? The Small VBA or many Worksheet Functions...? 0
Improve Excel Help Text - Make easier to Find Function Refs 0
What is fastest for this? Small VBA or many worksheet formulas...? 1

Top