On Tue, 2005-06-14 at 18:28 -0500, Peter Kupfer OOo wrote: > Mike Carmichael wrote: > > When calculating the TAN(89) the result OO 1.1.2 calc produces is > > 57.270343096. Per trig tables and a TI calculator, the value s/b > > 57.28996163. > > > > I've also noted that values returned from other OO 1.1.2 calc trig > > functions seem to be a bit less than the values the TI provides. > > > > Do I need to set Spreadsheet precision somewhere? > > Calc beta 1.9.108 gives the second value. > OOo 1.1.4 gives the second value also. > Try upgrading and see what happens. > Precision settings are in Tools > Options > Spreadsheet > Calculate.
The value of 1.6 people are getting is correct. The differences here in the 57.2 and the 1.6 values are based on degrees vs radians. If you are getting 1.6, then check the formula using =TAN(RADIANS(89)) instead and you should get the 57.2 value. Regards Jonathon -- OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase - http://mindmeld.cybersite.com.au/ Cybersite Consulting - http://www.cybersite.com.au/ Training4Linux - http://www.training4linux.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
