| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
| For chart syles, why doesn't color order match series order? | Charts and Charting in Excel | |||
| Error in formula displayed for linear and 2nd order curve fits inExcel 2003 | Charts and Charting in Excel | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Linear Mode
