Dear all,(adsbygoogle = window.adsbygoogle || []).push({});

I am currently using excel to work out some values for incident solar radiation but I am running into a rather frustrating problem when I try to do the following:

=COS(9.863)

my calculator tells me correctly this is 0.985.

however, when I put this in excel it decides it actually equals 0.905, which is obviously wrong.

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.

Cheers,

Tom

**Physics Forums | Science Articles, Homework Help, Discussion**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Frustrating excel problem with COS

**Physics Forums | Science Articles, Homework Help, Discussion**