Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
how to write tan^-1 in excel
1,467 views
Skip to first unread message
jonc...@gmail.com
Dec 18, 2019, 2:29:44 PM12/18/19
to
hi
im trying to write tan^-1 in excel
but keeps running into problems.
anyone know how to do this?
kind regards
john
im trying to write tan^-1 in excel
but keeps running into problems.
anyone know how to do this?
kind regards
john
Claus Busch
Dec 18, 2019, 2:49:26 PM12/18/19
to
Hi John,
Am Wed, 18 Dec 2019 11:29:41 -0800 (PST) schrieb jonc...@gmail.com:
> im trying to write tan^-1 in excel
> but keeps running into problems.
> anyone know how to do this?
if you have degrees of an angle in A1, then try:
=TAN(RADIANS(A1))^-1
or easier:
=COT(RADIANS(A1))
Regards
Claus B.
--
Windows10
Office 2016
Am Wed, 18 Dec 2019 11:29:41 -0800 (PST) schrieb jonc...@gmail.com:
> im trying to write tan^-1 in excel
> but keeps running into problems.
> anyone know how to do this?
=TAN(RADIANS(A1))^-1
or easier:
=COT(RADIANS(A1))
Regards
Claus B.
--
Windows10
Office 2016
dpb
Dec 18, 2019, 3:43:45 PM12/18/19
to
> hi
As most programming languages the function name is ATAN(). NB: its
argument is in radians, not degrees.
--
> im trying to write tan^-1 in excel
...
As most programming languages the function name is ATAN(). NB: its
argument is in radians, not degrees.
--
dpb
Dec 18, 2019, 5:42:30 PM12/18/19
to
On 12/18/2019 1:29 PM, jonc...@gmail.com wrote:
> hi
> im trying to write tan^-1 in excel
> but keeps running into problems.
> anyone know how to do this?
Function is ATAN() with argument in radians (not degrees)
> hi
> im trying to write tan^-1 in excel
> but keeps running into problems.
> anyone know how to do this?
--
0 new messages