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

Formula for converting Rupees in to words

Solved by Z. E. in 23 mins

I need help with formula for converting value

Solved by S. A. in 23 mins

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

Solved by C. D. in 18 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

=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