View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Customizing -2^2

In Excel the negation takes precedence over the power operator.

However, subtraction is a lower priority.
0-2^2
results in -4.

Does that help?


Regards,
Fred.

"Tim Walters" wrote in message
...
Shouldn't minus a squared number be a minus number? In Excel -2^2 = 4. To
keep it negative I have to write -(2^2). It's very easy to make mistakes
because I also work with Quattro Pro which works differently. Is there a
way to customize this in Excel so that -2^2 = -4?

Thanks.