| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
-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. |
Threaded Mode
