LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
P Keenan
 
Posts: n/a
Default MAJOR BUG: Excel operator precedence is wrong

If I enter in a cell "=-1^2" I should see "-1" as the value, not "1". If I
enter "=-A1^2" and the cell A1 contains the value "1", I should see "-1", not
"1". The binary operator "^" should have higher precedence than unary "-",
but does not. (It does have higher precedence than binary "-", as in "=2-2^2"
correctly gives the value "-2", not "0".)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions
 
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
Excel opens Hyperlinks with wrong application mcdirt Excel Discussion (Misc queries) 0 June 8th 06 05:08 AM
excel graphs line correctly, shows wrong value label? Need Help 123 Excel Discussion (Misc queries) 0 January 18th 06 07:12 PM
Excel 2003 has wrong timing using the worksheet_change macro Jan Excel Worksheet Functions 0 January 14th 06 06:30 AM
total and subtotal positions wrong in excel Mary Buck Excel Discussion (Misc queries) 1 September 15th 05 07:18 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 07:59 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"