Excel Math Bug
Tom Ogilvy wrote:
Precedence of operations is stated in the help. As far as I know,
there is no universally accepted order of precedence that covers all
combinations and permutations.
Again, sounds like your beef is with your consultant if you were
paying for his/her expertise in Excel.
Tom,
You are 100% right!
It sounds like he doesn't want to tell his client he wasted 1 week and
2000$ on something that simply can be found in the help. So the easy
way out is to blame MS for everything.
Welll... this is in my help (in Dutch)
Operator Beschrijving
– Negatief maken (zoals in –1)
% Procent
^ Machtsverheffen
* en / Vermenigvuldigen en delen
+ en – Optellen en aftrekken
& Twee tekenreeksen aan elkaar koppelen
= < <= = < Vergelijken
As you can see, a negative sign has precendence over power.
Unfortunately for Fred, a negative sign and a subtraction are
typographically identical. There is only one good solution: using
brackets.
--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?
|