View Single Post
Redbelly98
#4
Mar3-12, 12:58 PM
Mentor
Redbelly98's Avatar
P: 12,069
Frustrating excel problem with COS

Quote Quote by tommy060289 View Post
I've gathered this is an issue with excel giving the answer in Rads rather than degrees but I can not figure out how you force excel to output the correct answer (in degrees) and since I have thousands of calculations it isn't feasible for me to alter every one manually.
Just to clarify, hopefully you realize the output result of =cos(9.863) is not in radians, it is the input number 9.863 that Excel assumes is in radians.

Quote Quote by jtbell View Post
You can also use the RADIANS() function: COS(RADIANS(angle_in_degrees)).

And if you ever need to go the other way, there's a DEGREES() function: DEGREES(ACOS(x)).
I didn't know that, thanks for the tip!