View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default I am trying to find cotangent in the formulas.

"Robin" wrote:
In my calculator (degree mode) I place .185 and then pres
shift tan. The answer is 10.481 degrees.


It appears that you are talking about the arctan function, not cot. In
Excel:

=DEGREES(ATAN(0.185))


----- original message -----

"Robin" wrote in message
...
Joe,

I apologize for mentioning incorrect cotangent formula.
I have tried what you have suggested in excel. I must be missing
something.
Here is the scenario. There is a divergent angle the adjacent is 18.5 cm
and
the opposite is 100 cm. I then have .185. In my calculator (degree mode) I
place .185 and then pres shift tan. The answer is 10.481 degrees. I cannot
accomplish this in excel. I have tried many ways. I am sure it 10.48
degrees
since I have made a scaled diagram.


Sincerely

"JoeU2004" wrote:

"Robin" wrote:
I am trying to find cotangent in the formulas. there is sin and cosine
I
thought about trying to divided sin/cosine but it will not allow it.
After
sin() it is required to place a number in ().


Well, the cot = cos/sin. So, if A1 is the angle in radians, then:
cos(A1)/sin(A1).

On the other hand, cot = 1/tan. So: 1/tan(A1).

But note that the Excel function parameter is in radians. If A1 has the
angle in degrees, then: 1/tan(radians(A1))