+0  
 
0
182
2
avatar

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

Guest Apr 8, 2017

Best Answer 

 #2
avatar+26242 
+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.

Alan  Apr 8, 2017
edited by Alan  Apr 8, 2017
Sort: 

2+0 Answers

 #1
avatar+729 
-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. 

GingerAle  Apr 8, 2017
 #2
avatar+26242 
+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

21 Online Users

avatar
avatar
avatar
avatar
avatar
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.  See details