“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 want to make a wind rose chart. I have a table - Sites 1-6 at the top, seven clock times (11:00, 11:30 every half hour until 14:00) going down and then data filling the table (anything between 0 and 360). I need the chart to show the six sites as lines across the wind rose chart depending on the wind direction degrees (0-360).

Solved by K. D. in 28 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