Re: How do I do the inverse of tan in Excel?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi Bernard,

I was afraid of that, but took the OP's text literally:

<written as 1/tan or tan^-1>

Hopefully we get some sort of feedback to see what the intention was

--
Kind regards,

Niek Otten

"Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx> wrote in message
news:eqo86buPGHA.648@xxxxxxxxxxxxxxxxxxxxxxx
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" <nicolaus@xxxxxxxxx> wrote in message
news:%23rBrNLuPGHA.2300@xxxxxxxxxxxxxxxxxxxxxxx
=1/TAN(A1)
=TAN(A1)^(-1)

--
Kind regards,

Niek Otten

"MiddleEarthNet" <MiddleEarthNet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:E860C1B4-6886-4C96-BBD5-08A238ECBFD4@xxxxxxxxxxxxxxxx
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.






.



Relevant Pages

  • Re: Extreme calculations
    ... Kind regards, ... Microsoft MVP - Excel ... |> Do you have some sort of key to that thread? ...
    (microsoft.public.excel.programming)
  • Re: How to deal with ear fatigue?
    ... that I have to undo the next day. ... more of a sort of artistic brain fatigue in which a tune is heard so ... ignoring all kinds of error in a sort of self defence mechanism. ... Kind regards ...
    (rec.audio.pro)
  • Re: why does powerpoint file increase in size while printing
    ... Kind regards ... "Glen Millar" wrote: ... > This seems strange but it is sort of normal. ... > curious or are you having some sort of memory problem with this increase in ...
    (microsoft.public.powerpoint)
  • Re: Audi A6 Window Problem
    ... give vag a call and get them to sort it. ... Kind Regards ... Neil B ...
    (uk.rec.cars.maintenance)
  • Re: Vlookup Rounding
    ... Kind regards, ... > Sort your table Descending. ... >> For a plug number I have my current revenue set at 13,000,000. ... >> percentage and return the appropriate discount, ...
    (microsoft.public.excel.misc)