Cot

[Guest]

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

 

[Gord Dibben]

What is cot?

=(896.96/115.74)*cot


Gord Dibben MS Excel MVP

 

[Desert Piranha]

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

Is cot --> Cotangent

 

[Bondi]

Is cot --> Cotangent

Hi Lois Ann,

Mybey you can use the information on this link:

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

Regards,
Bondi

 

[Guest]

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]

Thanks for the info.

Gord

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

 

[Dave Peterson]

Cotangent isn't the ArcTan (ATan).

Cot = 1 / tangent

tangent = sin/cos
cotangent = cos/sin

 

[Guest]

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?

 

[Guest]

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.