ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you calculate cotangent in Excel 2003? (https://www.excelbanter.com/excel-worksheet-functions/184333-how-do-you-calculate-cotangent-excel-2003-a.html)

mowgli

How do you calculate cotangent in Excel 2003?
 


Dave Peterson

How do you calculate cotangent in Excel 2003?
 
=1/tan(a1)

But A1 holds radians--not degrees.

If A1 holds degrees, then:
=1/tan(radians(a1))
or
=1/tan(a1*pi()/180)

Look in Excel's help for Tangent.

mowgli wrote:

--

Dave Peterson

Dana DeLouis

How do you calculate cotangent in Excel 2003?
 
As a side note, it appears to me that "Derived Math Functions" was removed
from help in Excel 2007.
This link, I believe, is very similar to what was in Excel help in prior
versions...

http://msdn2.microsoft.com/en-us/library/w3t84e33.aspx

--
HTH :)
Dana DeLouis


"mowgli" wrote in message
...




All times are GMT +1. The time now is 02:44 PM.

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