Thread: Excel Math Bug
View Single Post
  #58   Report Post  
Posted to microsoft.public.excel.programming
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Excel Math Bug

"Tom Ogilvy" wrote...
Precedence of operations is stated in the help. As far as I know, there is
no universally accepted order of precedence that covers all combinations

and
permutations.

....

Somewhat of a tangent. APL and its descendants (APL2, J and K) have sepaate
tokens for numeric sign and minus operator. The numeric sign character is
part of the number token, so effectively always binds tighter than any other
token or operator. Evaluation is always right to left, so different results
are produced when using the sign character vs the minus operator followed by
a number raised to an even power. Excel treats unary minus like APL's sign
character rather than like APL's unary ('monadic') minus. This is unlike
most other programming languages that use the same character to represent
signs in numeric tokens and unary and 'diadic' minus.