View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Order of oprerations error?

That's the way excel documents the order of precedence. I don't think MS would
ever change this--it would mean that lots of people would have a reason to never
upgrade.

(Yes, it's not the order you learned in school.)

Marty F Humboldt wrote:

Why does -5*3^2 give 45 for a result? Shouldn't this be -45?
I thought this would be fixed in 2007 version- the 2003 version did the same.


--

Dave Peterson