Some help with excel 2007 plx

[Talshere]

Doing a bit of course work to simulate various functions of the menai strait, but I cant get excel2007 to work

When I put in "=(7.97+4.49)*COS((π2/365)*(A3-222))" Or any like for like representation of this, I get some crappy answer like 12.46 through all 365 days. Which I KNOW is wrong. In this equation A3 is the decimal day. The answer I SHOULD be getting for days 1 and 2 are 5.57462384241219 and 5.574622002 respectively.

I know what the problem is. The problem is the PI function. It needs to be 2PI radians. But can I HELL get it to do that. If I type 2PI it corrects it to PI2 and makes the 2 equal to the last PI integer +1, which doesnt even change the answer, so Ive no idea what its doing but its not right. If I force it to 2*PI I get #NAME?.

But I bloody KNOW it works. Ive got it here on my calculator........


ARRRRRRGHHHHHH!!!!!! >.<


Any? Please? Before I start bursting blood vessels.

 

[Berethond]

Try COS(((Pi*2)/365*(A3-222))

 

[Talshere]

Try COS(((Pi*2)/365*(A3-222))

=COS((PI*2)/365*(A3-222)) returns the result #NAME?



=7.97+4.49*COS((RADIANS(360)/365)*(A3-222)) Returns a real answer of 4.43051. Working out yearly temps from this equation I get a 365 day average of 7.96 degree C, which is in an acceptable range. But it leaves me with temps as low as 0.1 which seems more than a little on the cold side.