Hi, Rob! Many thanks for the prompt reply which now solved my problem.
Georges, thanks your advice I can report: it works, really! - WOW! As I am actually 63 years of age my schooltime is long time ago, of course. But when I saw the function RAD my brain started to remember. Working with the globe my granddaughter asked me why meridians are so far each other at the equator whereas all meet at the poles. And what is the difference between 10°E and 11°E at 54°N, where I live at the German coast of the Baltic Sea. Now, I can tell her by exact figure resulting by use of the resp. formula: =(2*PI()*6376*(COS(RAD(54)))/360. Again, many thanks! Kindest regards to all of you Michael D -------- Original-Nachricht -------- > Datum: Tue, 27 Nov 2012 11:15:28 -0500 > Von: Rob Weir <[email protected]> > An: [email protected], [email protected] > Betreff: Re: OpenOffice Calc > 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 > >>
