Customizing -2^2
Tim Walters wrote:
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.
In Excel help, type in "order of precedence."
First, Excel negates the 2.
Then it squares -2.
That results in +4.
I can't speak for Quattro Pro, as I haven't used it for years, but
always thought it was a better product than Lotus 1-2-3.
Bill
|