+0  
 
0
959
2
avatar

why does this website give me a different calculation than excel?

 Apr 8, 2017

Best Answer 

 #2
avatar+33614 
+5

Excel has a non-standard hierarchy rule for unary negation, which it places higher than exponentiation.

 

For example, most sensible pieces of calculational software calculate -3^2 as -9 because exponentiation has higher priority than negation.  However, Excel will return -3^2 as +9 because it gives unary negation a higher priority.  It doesn't give the binary operator the same priority though, so, in Excel 0 - 3^2 results in -9.  That is, in Excel,  -3^2 is different from 0 - 3^2.

 

(The macro language VBA, which comes with Excel does not exhibit this peculiarity.  It uses the standard priorities, so it returnes -9 for both -3^2 and 0 - 3^2.)

.

So, if your calculation included a unary minus, then it isn't surprising that you got a different answer from the calculator here.  If this isn't the explanation for your problem then specify the calculation here and we'll look at it in more detail.

 Apr 8, 2017
edited by Alan  Apr 8, 2017
 #1
avatar+2440 
-2

I just tested both with 2+2. Both gave the answer of 4. The Calculator and Excel seem to work fine. So, this means you are an imbecile of low order.  If you give an example, then someone may explain why. Then you will know to which low order of imbecile you belong. 

 Apr 8, 2017
 #2
avatar+33614 
+5
Best Answer

Excel has a non-standard hierarchy rule for unary negation, which it places higher than exponentiation.

 

For example, most sensible pieces of calculational software calculate -3^2 as -9 because exponentiation has higher priority than negation.  However, Excel will return -3^2 as +9 because it gives unary negation a higher priority.  It doesn't give the binary operator the same priority though, so, in Excel 0 - 3^2 results in -9.  That is, in Excel,  -3^2 is different from 0 - 3^2.

 

(The macro language VBA, which comes with Excel does not exhibit this peculiarity.  It uses the standard priorities, so it returnes -9 for both -3^2 and 0 - 3^2.)

.

So, if your calculation included a unary minus, then it isn't surprising that you got a different answer from the calculator here.  If this isn't the explanation for your problem then specify the calculation here and we'll look at it in more detail.

Alan Apr 8, 2017
edited by Alan  Apr 8, 2017

1 Online Users

avatar