RE: Cosine of 90 degrees

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

1. Computers work in binary is part of the explanation.
2. The algorithm used doesn't address 0 specifically, which may have been
corrected in 2010.
3. You can always apply ROUND(COS(RADIAN(A1)),10)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"mikelee101" wrote:

Hello All,
I was just curious why I wasn't getting zero for the result of the cosine of
a 90 degree angle. This formula

=COS(RADIANS(90))

returns

6.12574E-17

when I would have expected 0. Am I misusing a function in there somewhere?
Any thoughts would be greatly appreciated.

Excel 07, XPPro SP3.

Thanks.
--
Mike Lee
McKinney,TX USA
.

Relevant Pages

  • Re: What I learned from Class Viewer
    ... displaced by such a trivially easy algorithm? ... as the distance information dropped away. ... by simply assuming that the weight is a distance between nodes ... There isn't anything more I can do besides the general explanation, ...
    (comp.lang.java.programmer)
  • Re: Problem with Montgomery product
    ... > I read the paper "Analyzing and Comparing Montgomery Multiplication ... I think that the explanation is not very ... > difficult (because I didn't find a paper with an explicit explanation ... explain how the basic algorithm works from which you can figure out ...
    (sci.crypt)
  • Re: Distinct issues
    ... explanation of why code would have so many SELECT DISTINCT at all ... levels of nesting? ... do you know if there is a tool or algorithm that will ... find if a query returns duplicate rows or not for the general case? ...
    (microsoft.public.sqlserver.programming)
  • Re: Lexicons
    ... > Is there an algorithm for computing the shortest representation of a ... > given sequence of digits? ... > have no short explanation, and yet x is not normal? ... Normality is not necessarily connected with randomness, ...
    (sci.math)
  • Re: OT: computers for dummies?
    ... tHe operating system is the basic instructions such as the ... rules and conventions that govern travel on the streets ... I have tried that explanation many times. ... how computers work, ...
    (rec.audio.pro)