Here are some problems that our users have asked and received explanations on
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