“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=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

Hi! How can I change the setting to find the sine angle in degrees?

Solved by K. E. in 21 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

Hi ... I want to convert number into degrees.. can you please tell me the formula

Solved by C. D. in 18 mins

Looking to have Lat. Long in - Degrees Minutes Decimal Minutes 120* 23.2345' Can you do that?

Solved by O. H. in 26 mins