ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do I enter a formula to work out tangents (https://www.excelbanter.com/excel-programming/390716-how-do-i-enter-formula-work-out-tangents.html)

Simon Peachey

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?

Smallweed

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?


Tom Ogilvy

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?



All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com