Order of oprerations error?
 

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.

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

Order of oprerations error?
 

In EXCEL 2007 the result I get is:-

-45

Please hit Yes if my comments have helped.

"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.

Order of oprerations error?
 

You can check out:-

Formulas / Formula Auditing group / Evaluate Formula

- for more help if you want to.

Please hit Yes if my comments have helped.

Thanks.





"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.

Order of oprerations error?
 

And in Excel 2003
--
David Biddulph

trip_to_tokyo wrote:
In EXCEL 2007 the result I get is:-

-45

Please hit Yes if my comments have helped.

"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.