Thread: Excel Math Bug
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
Amedee Van Gasse[_3_] Amedee Van Gasse[_3_] is offline
external usenet poster
 
Posts: 102
Default 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?