I am trying to find cotangent in the formulas.
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))
|