How do I do the inverse of tan in Excel?
 

I know how to use the tan function in Excel 2003, but I need the inverse of
tan written as 1/tan or tan^-1) for a set of equations I'm doing. I've tried
various combinations of writing it with brackets to separate terms but it
still says there is an error.

How do I do the inverse of tan in Excel?
 

=1/TAN(A1)
=TAN(A1)^(-1)

--
Kind regards,

Niek Otten

"MiddleEarthNet" wrote in message
...
I know how to use the tan function in Excel 2003, but I need the inverse of
tan written as 1/tan or tan^-1) for a set of equations I'm doing. I've
tried
various combinations of writing it with brackets to separate terms but it
still says there is an error.

How do I do the inverse of tan in Excel?
 

Per Excel Help:

ATAN()
Returns the arctangent, or inverse tangent, of a number.

Is that what you're looking for?
(If not, check Excel's math and trig functions.)

***********
Regards,
Ron

XL2002, WinXP-Pro


"MiddleEarthNet" wrote:

I know how to use the tan function in Excel 2003, but I need the inverse of
tan written as 1/tan or tan^-1) for a set of equations I'm doing. I've tried
various combinations of writing it with brackets to separate terms but it
still says there is an error.

How do I do the inverse of tan in Excel?
 

Niek,
I think we have a language problem here.
Inverse of a trig function is the TAN^1(x) not (TAN(x))^-10.
We talk about Arcsine, Arctan so we use ASIN, ATAN
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Niek Otten" wrote in message
...
=1/TAN(A1)
=TAN(A1)^(-1)

--
Kind regards,

Niek Otten

"MiddleEarthNet" wrote in
message ...
I know how to use the tan function in Excel 2003, but I need the inverse
of
tan written as 1/tan or tan^-1) for a set of equations I'm doing. I've
tried
various combinations of writing it with brackets to separate terms but it
still says there is an error.