Cosine of 90 degrees
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
|