Group:  Microsoft Excel ยป microsoft.public.excel.newusers
Thread: Cot

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Cot
Lois Ann 01.08.2006 02:58:01
How do I divide one number by another and then multiply answer by the cot?
Example 896.96/115.74 *cot
--
Lois Ann
Re: Cot
Gord Dibben <gorddibbATshawDOTca> 01.08.2006 03:31:39
What is cot?

=(896.96/115.74)*cot


Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 19:58:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com>
wrote:

[Quoted Text]
>How do I divide one number by another and then multiply answer by the cot?
>Example 896.96/115.74 *cot

Re: Cot
Desert Piranha <Desert.Piranha.2bufoo_1154405909.6479[ at ]excelforum-nospam.com> 01.08.2006 04:15:04
Lois Ann Wrote: > How do I divide one number by another and then multiply answer by the > cot?
[Quoted Text]
> Example 896.96/115.74 *cot
> --
> Lois AnnHi, Lois,

Is cot --> Cotangent -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28934 View this thread: http://www.excelforum.com/showthread.php?threadid=566890
Re: Cot
"Bondi" <mbondorff[ at ]hotmail.com> 01.08.2006 07:44:32

Desert Piranha wrote:
[Quoted Text]
> Lois Ann Wrote:
> > How do I divide one number by another and then multiply answer by the
> > cot?
> > Example 896.96/115.74 *cot
> > --
> > Lois AnnHi, Lois,
>
> Is cot --> Cotangent
>
>
> --
> Desert Piranha
>
>
> ------------------------------------------------------------------------
> Desert Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28934
> View this thread: http://www.excelforum.com/showthread.php?threadid=566890

Hi Lois Ann,

Mybey you can use the information on this link:

http://support.microsoft.com/?kbid=213887

Regards,
Bondi

Re: Cot
paul 01.08.2006 08:43:02
cotangent is the "old way" of saying Tan-1,ie the tangent who's angle is
=degrees(atan(896.96/115.74)) =82.647


--
paul
paul.shepherd[ at ]nospamparadise.net.nz
remove nospam for email addy!



"Gord Dibben" wrote:

[Quoted Text]
> What is cot?
>
> =(896.96/115.74)*cot
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 31 Jul 2006 19:58:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com>
> wrote:
>
> >How do I divide one number by another and then multiply answer by the cot?
> >Example 896.96/115.74 *cot
>
>
Re: Cot
Gord Dibben <gorddibbATshawDOTca> 01.08.2006 16:33:12
Thanks for the info.

Gord

On Tue, 1 Aug 2006 01:43:02 -0700, paul <paul.shepherd[ at ]nospam.paradise.net.nz>
wrote:

[Quoted Text]
>cotangent is the "old way" of saying Tan-1,ie the tangent who's angle is
>=degrees(atan(896.96/115.74)) =82.647

Gord Dibben MS Excel MVP
Re: Cot
Dave Peterson <petersod[ at ]verizonXSPAM.net> 01.08.2006 17:36:44
Cotangent isn't the ArcTan (ATan).

Cot = 1 / tangent

tangent = sin/cos
cotangent = cos/sin



paul wrote:
[Quoted Text]
>
> cotangent is the "old way" of saying Tan-1,ie the tangent who's angle is
> =degrees(atan(896.96/115.74)) =82.647
>
> --
> paul
> paul.shepherd[ at ]nospamparadise.net.nz
> remove nospam for email addy!
>
> "Gord Dibben" wrote:
>
> > What is cot?
> >
> > =(896.96/115.74)*cot
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Mon, 31 Jul 2006 19:58:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com>
> > wrote:
> >
> > >How do I divide one number by another and then multiply answer by the cot?
> > >Example 896.96/115.74 *cot
> >
> >

--

Dave Peterson
Re: Cot
Lois Ann 01.08.2006 18:22:02
This helped some, but I still need the azimuth. When I put it into a
calculator, these are the steps I use.596.96/115.74=5.15777, then I cotangent
5.15777=79.0275 which is the azimuth. Now how do I put this into excel?
--
Lois Ann


"paul" wrote:

[Quoted Text]
> cotangent is the "old way" of saying Tan-1,ie the tangent who's angle is
> =degrees(atan(896.96/115.74)) =82.647
>
>
> --
> paul
> paul.shepherd[ at ]nospamparadise.net.nz
> remove nospam for email addy!
>
>
>
> "Gord Dibben" wrote:
>
> > What is cot?
> >
> > =(896.96/115.74)*cot
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Mon, 31 Jul 2006 19:58:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com>
> > wrote:
> >
> > >How do I divide one number by another and then multiply answer by the cot?
> > >Example 896.96/115.74 *cot
> >
> >
Re: Cot
Miguel Zapico 01.08.2006 20:35:02
Paul has given the formula before, with the original numbers of the post.
With the ones here the formula is:
=DEGREES(ATAN(596.96/115.74))
Type this in a cell and you will get the result you expect.

Miguel.

"Lois Ann" wrote:

[Quoted Text]
> This helped some, but I still need the azimuth. When I put it into a
> calculator, these are the steps I use.596.96/115.74=5.15777, then I cotangent
> 5.15777=79.0275 which is the azimuth. Now how do I put this into excel?
> --
> Lois Ann
>
>
> "paul" wrote:
>
> > cotangent is the "old way" of saying Tan-1,ie the tangent who's angle is
> > =degrees(atan(896.96/115.74)) =82.647
> >
> >
> > --
> > paul
> > paul.shepherd[ at ]nospamparadise.net.nz
> > remove nospam for email addy!
> >
> >
> >
> > "Gord Dibben" wrote:
> >
> > > What is cot?
> > >
> > > =(896.96/115.74)*cot
> > >
> > >
> > > Gord Dibben MS Excel MVP
> > >
> > > On Mon, 31 Jul 2006 19:58:01 -0700, Lois Ann <LoisAnn[ at ]discussions.microsoft.com>
> > > wrote:
> > >
> > > >How do I divide one number by another and then multiply answer by the cot?
> > > >Example 896.96/115.74 *cot
> > >
> > >

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net