I am trying to find cotangent in the formulas.
It worked well, I do onot understand what is behind the excel terminology
concerning this. I very much tahnk you for your help.
"JoeU2004" wrote:
"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))
|