The answer is 10.481 degrees. I cannot
accomplish this in excel.

Hi. Make sure you convert the Radian answer to Degrees.


=ATAN(0.185)

0.182931766

=DEGREES(0.182931766)

10.48121814

= = = = =
HTH :)
Dana DeLouis




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

It worked well.

I thank you for responding.

Robin
"Dana DeLouis" wrote:

The answer is 10.481 degrees. I cannot
accomplish this in excel.

Hi. Make sure you convert the Radian answer to Degrees.


=ATAN(0.185)

0.182931766

=DEGREES(0.182931766)

10.48121814

= = = = =
HTH :)
Dana DeLouis




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