LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cosine Function Returns Wrong Answer!

I have a problem with my Excel 2002 that is driving me nuts.

The cosine function returns the wrong answer for the cosine of 90 degrees.
The right answer is zero, of course, but Excel insists on returning a very
small number, 6e-17.

Cosine works fine for all other angles -- both smaller and larger than 90
degrees.

What the heck is going on? Even the simple little calculator that comes with
Windows gives the right answer.

Can anyone help?

Regards,

Gordon Arnaut
Ontario, Canada.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrong Answer Loren Excel Discussion (Misc queries) 5 December 11th 06 09:24 PM
Row() function returns wrong row and more.. Kim Excel Worksheet Functions 5 July 11th 06 02:11 AM
My Datedif function only returns 0's in the cell what's wrong? Tom Excel Worksheet Functions 1 April 13th 06 07:43 PM
month worksheet function returns wrong value Barry Excel Worksheet Functions 6 January 28th 06 12:37 AM
Logic statement returns wrong answer. Tony Excel Worksheet Functions 2 December 2nd 04 05:07 AM


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"