View Single Post
Mar3-12, 01:58 PM
frustrating excel problem with COS
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.
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!