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

In a recent multi, multi articled thread on this subject dealing with an
Excel formula =-5^2 returning +25, much discussion centred around precedence
of operations being responsible for the + result
Despite the many theories on this, an Excel formula =-5^3 returns -125.
In fact it would seem that any negative value raised to an EVEN power
retruns a positive result.
Whillst the same negative number raised to an ODD power returns a negative
result.

There are, of course simple workarounds like =0-5^2 and =-(5^2) to retrun
the apporpriate negative result.

However IMHO such inconsistency is still a Bug and is long overdue for a
fix.

Any other thoughts on this?

Regards

John Howard


 
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
Excel can't do basic math?! Steven Sinclair Excel Discussion (Misc queries) 18 August 21st 06 09:42 PM
Excel Math formulas [email protected] Excel Discussion (Misc queries) 2 November 16th 05 03:33 AM
Excel Math Wizards scain2004 Excel Worksheet Functions 3 October 12th 05 12:07 AM
Excel Math Bug fred Excel Programming 170 August 6th 04 10:05 AM


All times are GMT +1. The time now is 05:48 PM.

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"