LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #31   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 733
Default Excel Math Bug

"fred" wrote...
....
Why shouldn't a language calculate equations in the way a calculus teacher
would? ... Apparently they just don't. I'm guessing it's because
the programmers don't know the right way to do it, because most programmers
aren't mathematicians; or because there would be too much work involved at
any given point in the project. Why else?

....

Maybe because computers aren't usually working with equations or true real
(or complex) numbers. Computers generally deal with finite precision binary
arithmetic calculations, and those have complications that have ensnared
many mathematicians who don't appreciate the difference.

For instance, binary floating point addition and multiplication are both
commutative, as expected, but neither is strictly associative, only
approximately so. Evaluation order using the same operator is critical in
software development and usually not at all in mathematics.


 
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
Less Excel more Math Ty Excel Worksheet Functions 1 April 16th 11 06:28 AM
Math functions in Excel Farhad Excel Discussion (Misc queries) 2 February 19th 07 04:16 PM
Excel math formula dan Excel Worksheet Functions 4 October 30th 06 04:51 PM
How do I ? math/excel question Madduck Excel Discussion (Misc queries) 3 July 26th 06 05:41 AM
More math than excel, but a fun problem S Davis Excel Worksheet Functions 4 July 6th 06 10:04 PM


All times are GMT +1. The time now is 08:02 PM.

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

About Us

"It's about Microsoft Excel"