Thread: -1^2+1 vs 1-1^2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scriptick Scriptick is offline
external usenet poster
 
Posts: 8
Default -1^2+1 vs 1-1^2

In excel =-1^2+1 returns 2 while =1-1^2 returns 0.
What calculation rule decides this? Apparently in the first -1 is
interpreted as (-1), where in the second part - is interpreted as a
substraction operator. =-(1)^2+1 also returns 2.