Mike Carmichael wrote:
Sorry for the confusion & Thanks for all the help!
It should have mentioned that I needed the tangent of 89 Degrees & had
converted 89 to its radian equivalent using 57.296 as the number of
degrees in one radian before using TAN.
That is the entire explanation of your problem. 57.296 is an
insufficiently accurate approximation of 180/pi.
I'm going to download the beta upgrade now!
A good idea on general principles, but it isn't your problem. Use
RADIANS(89) instead of 89/57.296.
Regards,
Mike
Jonathon Coombes wrote:
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
--
John W. Kennedy
"The poor have sometimes objected to being governed badly; the rich have
always objected to being governed at all."
-- G. K. Chesterton. "The Man Who Was Thursday"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
