ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Cot (https://www.excelbanter.com/new-users-excel/102389-cot.html)

Lois Ann

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

Gord Dibben

Cot
 
What is cot?

=(896.96/115.74)*cot


Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 19:58:01 -0700, Lois Ann
wrote:

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



Desert Piranha

Cot
 

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...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=566890


Bondi

Cot
 

Desert Piranha wrote:
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...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=566890


Hi Lois Ann,

Mybey you can use the information on this link:

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

Regards,
Bondi


paul

Cot
 
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

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
wrote:

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




Gord Dibben

Cot
 
Thanks for the info.

Gord

On Tue, 1 Aug 2006 01:43:02 -0700, 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


Gord Dibben MS Excel MVP

Dave Peterson

Cot
 
Cotangent isn't the ArcTan (ATan).

Cot = 1 / tangent

tangent = sin/cos
cotangent = cos/sin



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

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
wrote:

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




--

Dave Peterson

Lois Ann

Cot
 
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

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
wrote:

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




Miguel Zapico

Cot
 
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:

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

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
wrote:

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




All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com