Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how do i calculate inverse tan?
0 views
Skip to first unread message
emma
Oct 5, 2006, 8:39:02 AM10/5/06
to
Hi, I have to calculate TAN y angle and I on my scientific calculator i would
do 8.391/14.142 *inv tan and get 30.68 degrees. I cannot seem to find out how
to do this in excel. Please help.
do 8.391/14.142 *inv tan and get 30.68 degrees. I cannot seem to find out how
to do this in excel. Please help.
vezerid
Oct 5, 2006, 8:48:34 AM10/5/06
to
=ATAN(8.391/14.142)*180/PI()
HTH
Kostis Vezerides
emma
Oct 5, 2006, 9:02:01 AM10/5/06
to
THANK YOU VERY MUCH.
vezerid
Oct 5, 2006, 9:24:20 AM10/5/06
to
You are welcome. Glad it worked.
Kostis
emma wrote:
> THANK YOU VERY MUCH.
>
David Biddulph
Oct 5, 2006, 10:34:52 AM10/5/06
to
... or
=DEGREES(ATAN(8.391/14.142))
--
David Biddulph
=DEGREES(ATAN(8.391/14.142))
--
David Biddulph
"vezerid" <vez...@act.edu> wrote in message
news:1160052514.1...@h48g2000cwc.googlegroups.com...
Bernard Liengme
Oct 5, 2006, 10:36:22 AM10/5/06
to
Excel does trig in radians hence the 180/PI()
To save you remembering which way to do this use the conversion function
So to find the Tan of 60 or of degree value in A1
=TAN(RADIANS(60)) or TAN)RADIANS(A1)
and to find the inverse tan (we oldies you we brought up with log 7 trig
paper tables call that the 'arc-tan')
=DEGREES(ATAN(A2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
To save you remembering which way to do this use the conversion function
So to find the Tan of 60 or of degree value in A1
=TAN(RADIANS(60)) or TAN)RADIANS(A1)
and to find the inverse tan (we oldies you we brought up with log 7 trig
paper tables call that the 'arc-tan')
=DEGREES(ATAN(A2)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"emma" <em...@discussions.microsoft.com> wrote in message
news:36A2C17F-EE00-4B66...@microsoft.com...
0 new messages