Excel should have a tan^-1 Cos^-1 and sin^-1

G

Guest

I can take tan (A) =b of a angle, to produce a fraction, but can't work back
to an angle using tan^-1 (b)=A

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
R

Ron Rosenfeld

On Sat, 10 Sep 2005 02:42:02 -0700, "Mark D T Jones" <Mark D T
I can take tan (A) =b of a angle, to produce a fraction, but can't work back
to an angle using tan^-1 (b)=A


Look up the definition of arctangent, then look at HELP for the ATAN worksheet
function. There is also ACOS and ASIN available to you.

ATAN

Returns the arctangent, or inverse tangent, of a number. The arctangent is the
angle whose tangent is number. The returned angle is given in radians in the
range -pi/2 to pi/2.


--ron
 
B

Bernard Liengme

You should know that SIN^-1(theta) is read as "arcsine of theta"
So Excel has functions such as ASIN, ACOS, etc.
Look before you leap.
 

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