Thread
:
-1^2+1 vs 1-1^2
View Single Post
#
1
Posted to microsoft.public.excel.programming
Scriptick
external usenet poster
Posts: 8
-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.
Reply With Quote
Scriptick
View Public Profile
Find all posts by Scriptick