“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

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?

Solved by O. H. in 26 mins

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

Solved by K. E. in 21 mins

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

Solved by C. D. in 18 mins