On Tue, Nov 27, 2012 at 11:13 AM, Georges Bolssens <[email protected]> wrote: > As my math professor in college used to say: Degrees are for drawing, > radians are for calculating ;-) >
Exactly. The input to COS() needs to be in radians. Michael can use the built-in RADIANS() function to convert from degrees to radians and pass that value in. -Rob > > On Tue, Nov 27, 2012 at 5:05 PM, <[email protected]> wrote: > >> >> To whom it may concern: >> ----------------------- >> >> In OpenOffice Calc I found incorrect values when using funktion COS(); >> >> e.g., formula: 2*PI()*R*COS(0°-90°Latitude) /360 = ... R=6376 km >> Result shall show difference in km between two meridians (longitudes) >> Only COS(0) delivers correct value=1 ==> 111,2821931072 km >> >> >> COS(45)= 0,5253219888 incorrect (correct = 0,707106781) >> >> Could you be so kind to give an explanation - or what did I do wrong? >> >> Many thanks in advance for your early reply. >> >> Kindest regards >> >> Michael D >>
