Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how do I enter a formula to work out tangents

I am trying to set up a speadsheet in exel to work out the angle of a
triangle, how can i input the formula to work out the Inv Tangent?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default how do I enter a formula to work out tangents

click on Fx (Insert, Function) and choose Math & Trig category - loads of
worksheet functions for this kind of thing, including ATAN

"Simon Peachey" wrote:

I am trying to set up a speadsheet in exel to work out the angle of a
triangle, how can i input the formula to work out the Inv Tangent?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default how do I enter a formula to work out tangents

ATAN

from help:
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.

--
Regards,
Tom Ogilvy


"Simon Peachey" wrote:

I am trying to set up a speadsheet in exel to work out the angle of a
triangle, how can i input the formula to work out the Inv Tangent?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula doesn't work unless hit enter again Whois Clinton Excel Discussion (Misc queries) 7 April 21st 23 02:59 PM
Formula doesn't work unless hit enter again Bobby Excel Worksheet Functions 7 May 31st 21 07:38 AM
Is there a way to make the enter button work as regular enter Ricter Excel Discussion (Misc queries) 1 November 17th 09 02:50 AM
Tangents Nick72 Excel Worksheet Functions 1 September 11th 09 09:29 PM
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. qwopzxnm Excel Worksheet Functions 2 October 20th 05 09:06 PM


All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"