Here are some problems that our users have asked and received explanations on
Im trying to write an equation along the lines tan^-1[((18-12.75)/8.75)-tan(51.534) and the answer should be 33.373 degrees im not sure what the issue is?
Solved by C. A. in 12 mins
=ATAN((COSB2*PI()/180)/(TANA3*PI()/180))
Can you tell me why this formulae that I have put into XL is showing the result #NAME?
I want to calculate the value of inverse tan of the cosine of cell B2 divided by the Tan of cell A3. I need the answer in degrees not radians.
I have a range of cells that I need to do this operation on
Can you spot the syntax error I am making?
Cheers,
John
Solved by K. Y. in 29 mins
I need to know the formula/symbol for tan-1
Solved by X. A. in 27 mins
I am trying to figure out the average speed and direction between 0-45, 45-90,91+ in degrees. The direction (DIR) is given in degrees while the speed (SPD) is given in mph. I am trying to input the formula into column V.
Solved by V. U. in 17 mins
Looking to have Lat. Long in - Degrees Minutes Decimal Minutes
120* 23.2345'
Can you do that?